Supported Native Excel Formatting

Data source types: Oracle Hyperion Planning

Table 16-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 16-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