Formatting Options

Formatting options are sheet level options, which are specific to the worksheet for which they are set

Note:

Not all data providers support all the options listed in Table 20-12. Refer to the Subtopics listed above to find the options supported for a particular provider.

To set options for cell formatting as described in Table 20-12, 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.

Table 20-12 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 Oracle Smart View for Office formatting and retain Excel formatting for ad hoc operations.

Note:

In ad hoc grids for all providers, Excel formatting is not retained when performing an Undo.

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.

This option is enabled when Use Excel Formatting is selected.

Note:

Formatting can affect performance, especially during ad hoc operations when Move formatting on operations is enabled.

Retain Numeric Formatting When you drill down in dimensions, retains the Excel formatting you have set when selecting the Excel 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.

This option is enabled when Use Cell Styles is selected.

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:

  • 1—All original values are divided by 10:

    cell value/10

    For example, 100/10=10, so 10 will be displayed.

  • 2—All original values are divided by 100: cell value/100

    For example, 100/100=1, so 1 will be displayed after refresh.

  • 3—All original values are divided by 1000:

    cell value/1000

    For example, 100/1000=0.1, so 0.1 will be displayed after refresh.

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:

  • -1—All original values are multiplied by 10:

    cell value*10

    For example, 100*10=1000, so 1000 will be displayed.

  • -2—All original values are multiplied by 100: cell value*100

    For example, 100*100=10000, so 10000 will be displayed after refresh.

  • -3—All original values are multiplied by 1000:

    cell value*1000

    For example, 100*1000=100000, so 100000 will be displayed after refresh.

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 Facilitates the readability of Oracle Hyperion Planning and Oracle Hyperion Financial Management forms by allowing member names to appear on each row of data.

In forms where repeated members are merged into one cell, member names may be out of the screen view, necessitating much back and forth scrolling between the member names and the row data. Selecting Repeat Member Labels helps make forms easier to read and use.

The sections that follow list the Formatting Options supported by provider.