Supported Native Excel Formatting
Table 21-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 Fusion Cloud Enterprise Performance Management web application.
Table 21-3 Supported Native Excel Formatting
Formatting | Smart View | Cloud EPM |
---|---|---|
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 Excel Formatting in Smart View
Saving Excel Formatting From an Ad Hoc Grid
Guidelines for Working with Native Excel Formatting and Forms in Cloud EPM