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.
Watch this overview video to get acquainted with some basic Oracle Smart View for Office functionality related to Planning, including specifying cell styles.
To specify a style:
Note:
There are no cell styles defined for Oracle Enterprise Performance Reporting Cloud.
Table 20-14 Cell Style Options Supported for Planning Forms and Ad Hoc
Option | Forms | Ad Hoc |
---|---|---|
Member cells | Member cells | Member cells |
Members | Yes | Yes |
Formula | Yes | No |
Data cells | Data cells | Data cells |
Locked | Yes | No |
Supporting details | Yes | Yes |
Read-only | Yes | Yes |
Cell Text | Yes | Yes |
Document Attachment | Yes | Yes |
Writable (lowest priority is recommended) | Yes | Yes |
Drill-through | Yes | Yes |