Table 7 summarizes the native Excel formatting supported by Planning forms in Smart View, and whether the formatting is supported when the form is viewed in the Planning web application.
Table 7. Native Excel Formatting Supported in Smart View and Planning
| Formatting | Smart View | Planning |
|---|---|---|
| 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 | ||
| 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 | ||
| 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 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 | ||
| Read-only | Yes | No |
| Column width and row height | Yes, in points | No |
Related Topics:
Saving Excel Formatting on a Planning Form
Viewing Formatting in Smart View
Saving Excel Formatting From an Ad Hoc Grid
Guidelines for Working with Native Excel Formatting and Planning Forms