Skip to main content

​
Approach 1: Use Saved Views for Export-Specific Layouts

Saved views let you define column visibility presets that you can activate before exporting. This is the recommended approach for most workflows.

​
Step 1: Define an Export View

Add a view entry to the views array in your sheet configuration that hides the columns you do not want in the export:

​
Step 2: Switch to the Export View Before Exporting

  1. Open the Nextedy RISKSHEET document
  2. Select the Export View from the saved views dropdown
  3. Click Export to Excel or Export to PDF
  4. After exporting, switch back to your default working view
An Export View Need Not Show Formula InputsSince v26.7.1, formula columns and the columns feeding them are evaluated whether or not they are shown, so an export view may hide them freely. If rpnNew depends on occNew, detNew, and sevNew, the calculation is correct with all four hidden. The export view is also safe to mark as the default view. See Formulas and Column Visibility, which also covers the behavior on earlier versions, where every formula column and its inputs had to stay visible.

​
Approach 2: Use hideColumns in PDF Export Scripts

For PDF exports, you can programmatically hide columns using the hideColumns parameter in your custom export script without changing the interactive view.

​
Step 1: Edit Your PDF Export Script

Open your risksheetPdfExport.vm template and call exportMainSheet with the hideColumns parameter:
The hideColumns parameter accepts a comma-separated list of column binding names. The specified columns are temporarily hidden during export and automatically restored afterward.

​
Step 2: Identify Column Binding Names

Find the bindings value for each column you want to hide in your sheet configuration:
Use the bindings values (not header or id) in the hideColumns parameter.

​
Comparison: Saved Views vs. hideColumns

diagram

​
Saving Personal Column Settings

You can also save personal column width and visibility preferences that persist across sessions:
  1. Adjust column widths and visibility as needed
  2. Use the Save Columns command to persist your settings
  3. Your preferences are saved per-user and apply each time you open the document
To restore the original column layout defined in the template, use the Reset Columns command. This removes all personal customizations and refreshes the sheet.
Combine Approaches for Complex WorkflowsUse saved views for team-wide export layouts defined in sheet configuration, and personal column settings for individual working preferences. The PDF hideColumns parameter handles cases where you need automated column hiding without user intervention.

​
Verification

After configuring column visibility for exports:
  1. For saved views: switch to your export view, confirm the target columns are hidden, then export
  2. For hideColumns: run the PDF export and open the generated file
You should now see the exported document without the hidden columns, while your interactive Risksheet retains all columns for editing.

​
See Also