Skip to main content

​
Set Default Visibility in Column Configuration

Each column definition supports a visible property that controls its default display state. Set visible to false to hide a column by default: 
{
  "columns": [
    { "binding": "title", "header": "Title", "visible": true },
    { "binding": "description", "header": "Description", "visible": false },
    { "binding": "severity", "header": "S", "type": "enum:severity" },
    { "binding": "helperCalc", "header": "Calc", "formula": "calcHelper", "visible": false }
  ]
}
When visible is not specified, it defaults to true. Hidden columns remain part of the configuration and can be made visible through saved views or the column visibility selector.

​
Use Saved Views for Predefined Layouts

Define multiple column visibility presets in the views array. Each view lists the column IDs to display: 
{
  "views": [
    {
      "name": "Full Analysis",
      "columns": ["systemItemId", "title", "sev", "occ", "det", "rpn", "taskId"]
    },
    {
      "name": "Review View",
      "columns": ["systemItemId", "title", "sev", "occ", "det", "rpn"]
    },
    {
      "name": "Export View",
      "columns": ["systemItemId", "title", "sev", "occ", "det", "rpn"]
    }
  ]
}
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 configuration defined in risksheet.json, removing all personal customizations. The sheet refreshes automatically after reset.
ActionScopePersistenceNotes
Column visible propertyAll usersPermanent (configuration)Set in risksheet.json
Saved views (views)All usersPermanent (configuration)Admin-defined presets
Select visible columnsPer userBrowser storageResets on view switch
Save columnsPer userServer-sideSurvives browser changes
Reset columnsPer userRemoves personal settingsConfirmation required

​
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: 
// In pdfscript.js — hide helper columns during export
exporter.exportMainSheet({
  hideColumns: "helperCalc,internalNotes"
});
Define an export-specific saved view to simplify this workflow for users who regularly export.
If the export view is the default, formulas in hidden columns will not execute on sheet load. This may cause incorrect calculated values. Always keep the full analysis view as default and switch to the export view only before exporting.

​
Verify Your Changes

You should now see the view selector dropdown in the toolbar with your defined views. Switching views should toggle column visibility immediately. The Select visible columns option should persist your choices until you switch views. The Reset columns command should restore the original configuration defined in risksheet.json.

​
See Also

KB ArticlesSupport TicketsSource Code
  • ToggleReviewCommand.ts
  • ResetColumnsCommand.ts
  • AppConfig.ts
  • SaveColumnsCommand.ts
  • ColumnsHelper.ts