Formatting options are sheet level options, which are specific to the worksheet for which they are set
To set options for cell formatting as described in Table 16, click Options on the Smart View ribbon, and then select Formatting in the left panel. When you are finished, make a selection for saving the changes:
OK
Save as Default Options
Apply to All Worksheets
Note: | The Apply to All Worksheets option is not available in PowerPoint or Word. |
See Sheet Options for a complete description of the above options.
Note: | Not all data providers support all the options listed in the table. |
Table 16. Number Formatting Options
| Option | Description |
|---|---|
| Formatting | Formatting |
| Use Thousands Separator | Use a comma or other thousands separator in numerical data. Do not use # or $ as the thousands separator in Excel International Options. |
| Use Cell Styles | Use formatting that is defined in Cell Styles or by the data provider. Overrides any user formatting. See Cell Styles. |
| Use Excel Formatting | Use Excel rather than Smart View formatting and retain Excel formatting for ad hoc operations. |
| Move Formatting on Operations | Copy parent cell formatting to zoomed in cells and retain this formatting even if the cell location changes after an operation. |
| Retain Numeric Formatting | When you drill down in dimensions, retains the Excel formatting you have set when selecting the Home ribbon, then Format, and then Format Cells. For example, if you chose to display negative numbers in red, then negative values will be displayed in red as you drill down on any member. |
| Adjust Column width | Adjust column widths to fit cell contents automatically. |
| Scale | Applies to ad hoc and forms. Overrides the setting defined in the form definition. Choose a positive or negative scaling option, and then click Refresh. Positive scaling: Divides original values by factors of 10. For example:
The pattern is similar for the remaining positive scaling options. Note that 0 will be displayed if the Decimal Places option is set to Default or 0. However, for a value such as 0.1 to display, the Decimal Places option must be set to 1. Negative Scaling: Multiplies original values by factors of 10. For example:
The pattern is similar for the remaining negative scaling options. Note: Work with the Decimal Places option to achieve the desired display result. |
| Decimal Places | Applies to ad hoc and forms. Overrides the setting defined in the form definition. Specify a decimal scale for the data values. For example, in Smart View, assume the decimal option selected is “1”. All values will change one decimal place to the right. If the original value is 50.56, then after refresh the value will be displayed as 50.5. Similarly, if option selected is “3”, then the displayed value will be 50.560. For forms, if Default is selected, then the form definition setting is applicable. Note: Work with the Scale option to achieve the desired display result. |
| Form | Form |
| Repeat Member Labels |