For information on saving and applying cell formatting in Smart View, see the Working with Smart View for Oracle Enterprise Performance Management Cloud Services.
The following tables summarize which Microsoft Excel formatting is supported in Smart View and Planning.
Fonts | Smart View | Planning |
---|---|---|
Font family | Yes | Yes |
Font size | Yes | Yes |
Bold | Yes | Yes |
Italic | Yes | Yes |
Strikethrough | Yes | No |
Underline | Only Single and Continuous | No |
Text color | Red, Green, and Blue | Red, Green, and Blue |
Background color | Plain, Solid, and Red, Green, and Blue | Plain, Red, Green, and Blue |
Alignment | Smart View | Planning |
---|---|---|
Vertical | Top, Center, and Bottom | No |
Horizontal | Left, Center, and Right | No |
Indent | Only Left Indent and five levels of indent | No |
Word wrap | Yes | No |
Borders Formatting | Smart View | Planning |
---|---|---|
Border color | Yes, can be set differently for each cell's four borders, and Red, Green, and Blue | Yes |
Border width | Yes, in points | Yes |
Border style | None, Solid, Double, Dotted, Dash, Dash-Dot, Dash-Dot-Dot | None, Solid |
Number and Dates | Smart View | Planning |
---|---|---|
Number format | Decimal places, negative and positive suffixes, prefixes, and color, eight colors, Percentage, Scientific format, presence of thousands separator | No |
Date format | Long and short dates, Hour, Minutes, Seconds, AM and PM | No |
Other | Smart View | Planning |
---|---|---|
Read-only | Yes | No |
Column width and row height | Yes, in points | No |