Viewing Formatting in Smart View

Data source types: Planning, Planning Modules, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Tax Reporting

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:

Open a Planning form and click the Apply button within the Formatting group on the Planning ribbon (see Figure 22-18).

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 22-18 Apply Options
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.
The option selection is immediately applied to the form.
To clear the selection made in the previous step, click the Clear button within the Formatting group.

See Clearing Formatting for more information.