Formatting Options Supported for Planning Forms and Ad Hoc

Table 5-11 Formatting Options Supported for Planning Forms and Ad Hoc

Option	Forms	Ad Hoc
Use Cell Styles	Yes	Yes
Use Excel Formatting —Move Formatting on Operations	No	Yes
Retain Numeric Formatting	Yes	Yes
Adjust Column Width and Row Height	Yes	Yes
Freeze Row and Column Headers	Yes	If Smart View Ad Hoc Behavior option is set to Standard: Yes If Smart View Ad Hoc Behavior option is set to Native: No
Scale	Yes	Yes
Use Custom Number Format	Yes	Yes
Use Thousands Separator	Yes	Yes
Decimal Places	Yes	Yes
Negative Number Format	Yes	Yes
Repeat Member Labels	Yes	Yes

Note:

Planning, Planning Modules, Financial Consolidation and Close, and Tax Reporting: If Disable formatting is enabled in the form definition in the web application, then the options you select in the Formatting tab in Oracle Smart View for Office are not honored in forms.