Data Suppression Options now Available as Global Options for Empty Sheets in Google Sheets

The data suppression options present in the Data tab in Smart View Options can now be set on an empty sheet in Google Sheets. This enables you to open ad hoc grids with missing data properly in Oracle Smart View for Google Workspace.

Applies to: Planning and Budgeting, Profitability and Cost Management, Close Management and Consolidation, FreeForm, Tax Reporting

Earlier, if data suppression options were enabled and saved as default, an ad hoc grid with missing data did not open in an empty sheet, as there would be no valid rows of data in the grid. To open such a grid, you first needed to clear the data suppression options in the Data tab of Smart View Options. However, to access the Data tab itself, you had to find and open another ad hoc grid with valid data, as the Data options were only sheet-level option.

Now, the Row Suppression, Column Suppression, and Block Suppression options in the Data tab are available as global options, thus enabling you to access and set them even from an empty sheet.

To open an ad hoc grid with data suppression enabled and no valid data rows, you can open Smart View options, go to the Data tab, and clear any data suppression options that are preventing the ad hoc grid from opening. These changes are saved back to the default options as your preferred settings. Once the ad hoc grid is open, the options in the Data tab become sheet-level options.

Business Benefit: Users can now access the data suppression options in empty sheets to open ad hoc grid with data suppression enabled and no valid data rows successfully.

Key resources