Formatting Options Supported for Essbase Ad Hoc
Table 5-12 Formatting Options Supported for Essbase Ad Hoc
Option | Ad Hoc |
---|---|
Use Cell Styles | Yes |
Use Excel Formatting
—Move Formatting on Operations |
Yes |
Retain Numeric Formatting | No |
Adjust Column Width and Row Height | Yes |
Freeze Row and Column Headers | Yes |
Scale | Yes |
Use Custom Number Format | Yes |
Use Thousands Separator | Yes |
Decimal Places | Yes |
Negative Number Format | Yes |
Repeat Member Labels | No |
Note:
For Essbase, if the number formatting options are not set or retained as default in Smart View Options, then the existing behavior of using the General format for numbers will continue for Essbase ad hoc grids.