Setting Smart View Form Options

Specify options for form display in Oracle Smart View for Office.

To set Smart View form options:

  1. Open the form, and then click Layout.
  2. 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.

    See Designing Flex Forms

    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.

    See Designing Flex Forms

  3. Click Save to continue, or Finish to save and close the form.