Viewing Formatting in Smart View

Data source types: Oracle Hyperion Planning

Once a form is rendered within Excel, Oracle Smart View for Office provides the options to view the formatting on a sheet. These options are accessed from the Apply button within the Formatting group on the Planning Ad Hoc ribbon.

Tip:

The Apply options are viewing options only and allow you to display the cell styles and native Excel formatting that were previously saved on a form.

To toggle between formatting view options on a Planning form:

  1. Open a Planning form and click the Apply button within the Formatting group on the Planning Ad Hoc ribbon (see Figure 15-2).

    The Apply options are displayed. The initial state before any option is selected is that no option is selected. Once an option is selected, the last option selection will be preserved the next time the form is opened.

    Figure 15-2 Apply Options


    Apply options: Non, Cell styles, Custom styles, Custom and cell styles.
  2. Select an option:

    • None—Applies no styles (Excel formatting or Smart View cell styles) to the sheet. Though cell styles or custom styles may exist on the sheet, neither are shown when selecting this option. They are preserved, however, if you want to display them later using the Cell styles, Custom styles, or Custom and cell styles options.

    • Cell styles—Applies only Smart View cell styles to the sheet, as described in the "Cell Styles" topic.

    • Custom styles—Applies only custom user-defined native Excel formatting to the sheet.

    • Custom and cell styles—Applies both Excel formatting and Smart View cell styles to the sheet. Note that when you select Custom and cell styles, cell styles take precedent over custom Excel formatting.

    Related Topics:

    Saving Excel Formatting on a Planning Form

    Clearing Formatting

    Saving Excel Formatting From an Ad Hoc Grid

    Supported Native Excel Formatting

    Guidelines for Working with Native Excel Formatting and Planning Forms