Skip to main content

Set Default Visibility in Column Configuration

Each column definition in the sheet configuration supports a visible property that controls its default display state. Set visible to false to hide a column by default:
When visible is not specified, it defaults to true. Hidden columns remain part of the sheet configuration and can be made visible through saved views or the column visibility selector. Note that bindings is the property that maps a column to a Polarion work item field. The sheet configuration file (risksheet.json) is editable through a YAML editor with syntax highlighting and validation in v25.5.0 and later.

Use Saved Views for Predefined Layouts

Define multiple column visibility presets in the views array. Each view lists the column IDs to display using the columnIds property:
Views support several powerful mechanisms for selecting which columns appear:
  • columnIds — the array of column IDs to display in this view. This is the correct property name; the legacy form columns is not recognized by the engine.
  • defaultView: true — marks which view loads automatically when the sheet opens (v24.1.0+). At most one view should set this. If no view is marked, the first view in the array becomes the initial selection.
  • "@all" — a special shorthand that includes every column defined in the sheet configuration, in declaration order.
  • "-columnId" — a hyphen prefix excludes a specific column from the selection. This is most useful combined with "@all": start from every column, then remove a few.
Users switch between views using the view selector in the toolbar. The grid immediately updates to show only the columns listed in the selected view.
diagram
If a formula column is hidden, its formula does not execute on sheet load. Do not rely on hidden formula columns for calculations that other visible columns depend on. Use saved views to control export layouts rather than permanently hiding formula columns.

Enable Personal Column Selection

Users can further customize their view using Select visible columns in the toolbar. This setting persists on the user’s local computer across sessions.
The Select visible columns selection is saved to the user’s browser storage. However, switching to a different saved view resets any personal column visibility changes. After switching views, users need to re-apply their personal column preferences.

Save and Reset Column Settings

Users can persist or restore their column width and visibility customizations:
  • Save columns — saves the current column width and visibility as personal settings. A confirmation prompt prevents accidental saves.
  • Reset columns — restores column width and visibility to the default sheet configuration, removing all personal customizations. The sheet refreshes automatically after reset.

Toggle Review Columns

Review columns can be toggled independently using the review toggle command. This shows or hides the review and add-review system columns (SYSTEM_COL_REVIEWS and SYSTEM_COL_REVIEWSADD), and automatically adjusts row heights to accommodate the changed layout.
The collapseTo column group collapse state resets on every page reload. For persistent column hiding, use saved views or the Select visible columns feature instead of relying on column group collapsing.

Control Visibility in Exports

For PDF exports, use the hideColumns parameter to temporarily hide columns during the export process. Columns are hidden during export and automatically restored afterward:
A cleaner alternative is to define an export-specific saved view that uses "@all" with -columnId exclusions to omit helper columns, then switch to it before exporting.
If the export view is marked with defaultView: true, formulas in hidden columns will not execute on sheet load. This may cause incorrect calculated values. Always keep the full analysis view as the default and switch to the export view only immediately before exporting.

Verify Your Changes

You should now see the view selector dropdown in the toolbar with your defined views. The view marked defaultView: true should be selected on initial load. Switching views should toggle column visibility immediately, including correct handling of "@all" and -columnId exclusions. The Select visible columns option should persist your choices until you switch views. The Reset columns command should restore the original sheet configuration.

See Also

Last modified on July 10, 2026