Advanced Options
Set Advanced Options for administrative and other advanced tasks.
Options in the Advanced tab are global options that apply to the entire current spreadsheet, including new sheets added to the current spreadsheet, and become the default for all existing and new spreadsheets.
The Advanced tab of the Options dialog is always available. You can access the Advanced tab before performing operations, such as performing ad hoc, opening a form, setting the active connection for the sheet, or setting the connection for functions.
To set advanced options:
- In the Extensions menu, select Smart View for Google Workspace, and then select Options.
- In the Options dialog, select the Advanced tab.
- Make selections in the Advanced tab as described in Advanced Options.
- Optional: Continue making changes to options in the Data, Members, or Formatting tabs.
- Click OK to save the changes.
Advanced Options
Table 5-1 Advanced Options
| Option | Description |
|---|---|
| General | General |
| Save Current Options as Default |
Select to save your modified option selections in the Data, Member, and Formatting tabs. After saving, your options selections become the default for any new content that you import from a data source. 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. |
| Logging | Logging |
| Enable diagnostics | Select to enable diagnostics. |
| Enable client logging | Select to enable client logging. |
| Show Log | Click to display the Smart View log in a separate window. You can view the log in the window or download it to a file. |
| Clear Storage | Click to clear the storage cache. The storage cache include any previously-selected options on the Advanced tab, as well as on the Data, Members, and Formatting tabs. |
| User-Defined Function | User-Defined Function |
| Missing Label | Specify a value for missing data in user-defined functions. |