Supported Native Excel Formatting

Data source types: Planning, Planning Modules, Enterprise Profitability and Cost Management, Financial Consolidation and Close, FreeForm, Tax Reporting

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

Clearing Formatting

Saving Excel Formatting From an Ad Hoc Grid

Guidelines for Working with Native Excel Formatting and Forms in EPM Cloud