About Smart View Formatting in Planning Forms
Depending on administrative settings (described in the Oracle Hyperion Planning Administrator's Guide), a Oracle Hyperion Planning form may display the cell formatting that you saved in Oracle Smart View for Office.
See the Oracle Smart View for Office User's Guide.
The following tables summarize which Microsoft Excel formatting is supported in Smart View and Planning.
| Fonts | Smart View | Planning |
|---|---|---|
| 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 | Smart View | Planning |
|---|---|---|
| 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 Formatting | Smart View | Planning |
|---|---|---|
| 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 Dates | Smart View | Planning |
|---|---|---|
| Number format | Decimal places, negative and positive suffixes, prefixes, and color, eight colors, Percentage, Scientific format, presence of thousands separator | No |
| Date format | Long and short dates, Hour, Minutes, Seconds, AM and PM | No |
| Other | Smart View | Planning |
|---|---|---|
| Read-only | Yes | No |
| Column width and row height | Yes, in points | No |