Supported Native Excel Formatting
Data source types: Oracle Hyperion Planning
Table 26-3 summarizes the native Excel formatting supported by Oracle Hyperion Planning forms in Oracle Smart View for Office, and whether the formatting is supported when the form is viewed in the web application.
Table 26-3 Native Excel Formatting Supported in Smart View and Oracle Hyperion Planning
Formatting | Smart View | Oracle Hyperion Planning |
---|---|---|
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 an Oracle Hyperion Planning Form
Viewing Formatting in Smart View
Saving Excel Formatting From an Ad Hoc Grid
Guidelines for Working with Native Excel Formatting and Oracle Hyperion Planning Forms