Cell Styles

Cell style options are global options, which apply to the entire current workbook, including any new worksheets added to the current workbook, and to any workbooks and worksheets that are created henceforth. Changes to global option settings become the default for all existing and new Microsoft Office documents.

It is not necessary to use Apply to All Worksheets or Save as Default Options with these options.

On the Cell Styles page, you can specify formatting to indicate certain types of member and data cells. Because cells may belong to more than one type—a member cell can be both parent and child, for example—you can also set the order of precedence for how cell styles are applied.

Note:

Refer to the Subtopics listed above to find the options supported for a particular provider.

Watch this overview video to get acquainted with some basic Oracle Smart View for Office functionality related to Planning, including specifying cell styles.

video icon Overview video

To specify a style:

  1. Expand the list of available cell types.
  2. Select a cell type.
  3. Select Properties and specify a font, background color, or border.

    Smart View allows the setting of only one style per cell type.

    For example, you may set a background style or a font style for Parent members, but you cannot set both a background and font style for Parent members.

  4. To re-order precedence of cell styles, use the Move Up and Move Down buttons or drag and drop the cell styles.
  5. Click OK. The setting takes effect after you refresh or perform a drill operation.
  6. Optional: To revert cell styles or precedence to the default styles of the connected Smart View provider, click Default Styles.
  7. Optional: To set your selections on this page as default settings, click the arrow in the OK button, and then select Save as Default Options.

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

Note:

There are no cell styles defined for Oracle Enterprise Performance Reporting Cloud.