Set Default Visibility in Column Configuration
Each column definition in the sheet configuration supports avisible property that controls its default display state. Set visible to false to hide a column by default:
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 theviews array. Each view lists the column IDs to display using the columnIds property:
columnIds— the array of column IDs to display in this view. This is the correct property name; the legacy formcolumnsis 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.
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.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 thehideColumns parameter to temporarily hide columns during the export process. Columns are hidden during export and automatically restored afterward:
"@all" with -columnId exclusions to omit helper columns, then switch to it before exporting.
Verify Your Changes
You should now see the view selector dropdown in the toolbar with your defined views. The view markeddefaultView: 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
- Create Saved Views — define saved view presets in detail
- Control Column Visibility in Exports — export-specific visibility
- Work with Formulas and Hidden Columns — formula interaction with visibility
- Control Column Visibility — column-level visibility settings