Unsupported functions in exports to MS Excel
In exports to MS Excel, some functions are replaced by the values that they
return.
This table shows the functions that a replaced by the values that they return:
| Application Studio Specific functions | Property functions | OLAP functions |
|---|---|---|
| SUMIF2 | MERGEPROPERTIES | MEMBERGETMULTI |
| GROWTHX | GETKEYVALUES | CELLWRITE |
| GROWTHY | GETPROPERTYVALUES | NOTEGET |
| LINESTM | GETPROPERTY | CELLPROPERTYGET |
| LINESTB | GETKEYS | ROK |
| LINESTR | GETPROPERTIES | KEYGET |
| LOGESTB | SETPROPERTY | MEMBERCNAME |
| LOGESTR | RON | |
| TRENDX | RWDB | |
| TRENDY | CROSSLINK | |
| WBC | ||
| RWA | ||
| RDB | ||
| HYPERLINK | ||
| RWC | ||
| CHECKSUM | ||
| CELLPROPERTYGETMULTI | ||
| GETTICKET | ||
| NOTEWRITE | ||
| CELLPROPERTYWRITE | ||
| MEMBERGET | ||
| HTML | ||
| MEMBERNAME | ||
| CELLGET | ||
| RWN | ||
| DBEXECUTE | ||
| TRANSLATESTRING | ||
| GETLEVEL | ||
| ROA | ||
| WBA | ||
| HYPERBLOCK | ||
| ROC |
Excel does not support graphics in number formats. When exported to Excel Workbook values format, the graphic is replaced by the value which it represents.
With some exceptions, Excel does not support number formats with more than three sections. The exceptions are number formats of four sections in which the fourth section is a string and does not have a condition. An example of an acceptable four-section format is an Accounting number format.