- Administering Planning
- Accessing More Administrative Tasks
- Administering Forms
- Creating Forms
- Defining the Layout
- Setting Smart View Form Options
Setting Smart View Form Options
Specify options for form display in Oracle Smart View for Office.
To set Smart View form options:
- Open the form, and then click Layout.
-
Select Smart View Options, and then settings such as:
Table 23-19 Smart View Options
Option Description Disable spreading
Disables spreading options in Smart View, including default spreading, spreading data for time periods, spreading using grid spread, and spreading using mass allocations.
Disable formatting
Disables the Formatting options (Save, Clear, Apply) on the provider ribbon in Smart View.
Repeat member labels
Allows repeated member labels in forms.
If this setting is cleared, you may override it in Smart View to allow repeated members in forms by selecting Repeat Member Labels in the Smart View Options dialog, Formatting tab.
For forms with Enable drop-down for dimensions selected (Segment property), the form layout will automatically behave as if the Repeat member labels option is selected, regardless of whether or not it is selected.
For flex forms (see Enable flex form for rows and Enable flex form for columns below), the Repeat member labels option is automatically enabled and cannot be cleared.
Disable sheet protection
Disables protection on data cells in forms in Smart View.
Allows users to enter or paste data into cells, but does not allow users to submit the changed data.
By default, this option is cleared.
Enable flex form for rows
Enables the form as a flex form on rows in Smart View.
When this option is enabled, the Repeat member labels option is automatically enabled, and cannot be cleared.
Enable flex form for columns
Enables the form as a flex form on columns in Smart View.
When this option is enabled, the Repeat member labels option is automatically enabled, and cannot be cleared.
- Click Save to continue, or Finish to save and close the form.