Supported Native Excel Formatting
Data source types: Planning, Planning Modules, Financial Consolidation and Close, Tax Reporting
Table 16-3 summarizes the native Excel formatting supported by forms in Oracle Smart View for Office, and whether the formatting is supported when the form is viewed in theOracle Enterprise Performance Management Cloud web application.
Table 16-3 Supported Native Excel Formatting
Formatting | Smart View | EPM Cloud |
---|---|---|
Font | Font | Font |
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 | Alignment | Alignment |
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 | Borders | Borders |
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 date format | Number and date format | Number and date format |
Number format | Decimal places, negative and positive suffixes and prefixes, negative and positive color, eight colors, Percentage, scientific format, presence of thousand separator | No |
Date format | Long and Short Dates, Hours, Minutes, Seconds, AM and PM | No |
Miscellaneous | Miscellaneous | Miscellaneous |
Read-only | Yes | No |
Column width and row height | Yes, in points | No |
Related Topics:
Saving Excel Formatting on a Form
Viewing Formatting in Smart View
Saving Excel Formatting From an Ad Hoc Grid
Guidelines for Working with Native Excel Formatting and Planning Forms