Setting Smart View Options

Set options for displaying data, members, formatting, and advanced settings using the Smart View Options.

In Smart View, you can set options at two levels — Global and Sheet.

Setting Global Options

Global options apply to the entire current workbook, including any new sheets added to the current workbook, and to workbooks that are created later. Changes to global options also affect existing sheets and workbooks.

• The options that appear on the Advanced tab of the Options panel are global options. You can access these options from an empty sheet also.
• The Row Suppression, Column Suppression, and Block Suppression options in the Data tab are also global options.

The following is an example of the Advanced tab of the Options panel. In this example, the Number of Undo Actions is changed from the default 0 to 4, and Enable diagnostics is selected (default is unselected). With these options, you can perform up to 4 undo operations and enable diagnostics on all sheets in the workbook.

Figure 5-1 Options Panel, Advanced Tab

For more information, see Advanced Options.

Setting Sheet Options

Sheet options are specific to the sheet for which they are set. The options that appear on the Data, Members, and Formatting tabs of the Options panel are sheet options.

You can apply your sheet option selections to all sheets in the current workbook by clicking the Apply to All Sheets button at the bottom of the Options panel.

For more information, see:

• Data Options
• Member Options
• Formatting Options

Saving Options as Default

You can save your preferred sheet options that you have set in the Data, Members, and Formatting tabs as default. Saving options as default helps you to automatically apply the same options to any future grids you create or import in Smart View.

To save options as default, first set your preferred options in the Data, Members, and Formatting tabs. Then, go to the Advanced tab and click Save Current Options as Default.

Note:

Changes made in the Advanced tab automatically become the default settings. You do not need to select the Save Current Options as Default command to save the Advanced options.

Clearing Saved Options or Resetting Options

You can reset or clear the options you have saved as default in the Data, Members, and Formatting tabs. To clear saved options, go to the Advanced tab and click Clear Saved Options. This clears the options you saved earlier and resets the settings to default Smart View options.

Note:

The Clear Saved Options action does not clear the options you have set in the Advanced tab. To clear the Advanced options along with current session related cache, click Clear Storage.