Viewing Excel Formatting in Smart View

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 provider 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.

Note:

This procedure describes the formatting displayed in Forms 1.0 where no design-time formatting is implemented. If you are working with design-time formatting in Forms 2.0, see Working with Design-time Formatting in Forms 2.0

To switch between formatting view options on a form:

Open a form and click the Apply button within the Formatting group on the provider ribbon; for example, the Planning ribbon.

The Apply options are displayed (Figure 21-18). The first time using this menu, 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 a form is opened.

Figure 21-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.

You can also use the Clear action to clear any saved formatting, as described in Clearing Formatting for more information.