Setting Form Grid Properties

To set form grid properties:

1. Open the form, and then click Layout.
2. In Grid Properties, set row and column properties as follows:

   Table 11-1 Form Grid Properties

   Option	Description
   Suppress missing blocks	On multiple rows: Greatly improves the efficiency of Suppress missing data. This option can degrade performance if no or few rows are suppressed. Test forms before and after using this setting to determine if performance is improved. Note that if you use this option: Some suppressed blocks may ignore Dynamic Calc members Row members may not indent
   Suppress missing data	Hide rows or columns without data. Clear to display rows or columns with "#MISSING" in cells when data is missing.
   Suppress invalid data	Hide rows or columns with invalid data. Clear to display rows or columns that contain cells with data that is invalid. Cells with invalid data are read-only.
   Default row height	Medium: Size-to-Fit: Force all rows to fit in the displayed space Custom: Select a custom size in pixels for the row height
   Default column width	Small: Display seven decimal places Medium: Display 10 decimal places Large: Display 13 decimal places Size-to-Fit: Force all columns to fit in the displayed space based on the top data cell value Custom: Select a custom size to display more than 13 decimal places, up to 999 places
   Global Assumptions Form	To enable transferring global assumptions from a test to a production environment for a simple form, select Global Assumptions Form. Then update the form to store global assumptions such as a tax rate.
   Suppress invalid Scenario/Time Periods	Hide invalid Scenario/Time Periods.
   Suppress Missing also Suppresses Zero	When this option is selected along with the Suppress missing data option for forms, all rows or columns containing both #Missing and zeroes are suppressed. When selected, this setting overrides the runtime suppression selections made for suppressing missing data or zeroes in Oracle Smart View for Office
   Remove Form Suppressions in Ad Hoc	Select to allow Smart View users to perform ad hoc analysis on a form that has other suppression options specified. If there is missing data on the form, the base dimension members for the columns or rows are displayed on the ad hoc grid in Smart View. This allows users to continue ad hoc analysis on the form, even though suppression options were enabled in form design. Note: Selecting this option does not override any suppression options users may have set in the Smart View Options dialog, Data Options tab. If the Remove Form Suppressions in Ad Hoc option is enabled for the form, and users see an error when performing ad hoc analysis on the form, then they should clear the suppression options in Smart View.
   Enable Calc On the Fly	When you select this option, in Forms 2.0, when you hover over a cell with a member formula attached, you see the member formula associated with the cell and you can perform calc on the fly. Calc on the fly allows you to perform calculations without having to submit your changes.

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