Calculated Columns Missing in Exports

Symptoms

Calculated columns (columns with a formula property) display correct values in the Nextedy RISKSHEET grid but appear empty or inconsistent in exports. This affects both Excel and PDF output.

Imported items have empty calculated valuesItems imported into Polarion via scripts or bulk import do not trigger Risksheet formula execution. The calculated column values are not stored in Polarion fields until the item is edited in Risksheet. Exports read field values from Polarion, so they show empty cells for these items.

Fix: Sync Formula Values (v24.5.1+)

Risksheet version 24.5.1 introduced a data sync feature for formula columns that ensures calculated values are stored to Polarion fields.

Update Risksheet to version 24.5.1 or later
Open the affected Risksheet document
The data sync feature automatically persists formula column values to Polarion fields

For older versions, the workaround is to manually edit each affected item in Risksheet to trigger formula execution and value persistence.

Version 24.5.1 data syncStarting with version 24.5.1, Risksheet automatically syncs formula column values to Polarion fields, resolving the empty export issue for both new and imported items.

Fix: Formula Column Missing from the Export

A calculated value is exported only when its column is part of the exported layout. Since v26.7.1, whether the formula executes is no longer part of this — a formula column calculates whether or not it is shown — so a missing value in an export is a layout question, not a calculation one.

Confirm the formula column is included in the view you export from
Use saved views to define export-specific layouts, listing the columns the export should contain
If the value must also exist in Polarion (for OData exports or Lucene queries), set readOnly: false on the column so the calculated value is stored

views:
- name: Export View
  columnIds:
  - id
  - title
  - severity
  - occurrence
  - rpn
  - rpnNew
- name: Editing View
  columnIds:
  - id
  - title
  - severity
  - occurrence
  - detection
  - rpn
  - mitigation
  - rpnNew

An export view is safe as the defaultSince v26.7.1, a restricted column set does not prevent any formula from executing, so an export-specific saved view may be the default view. On earlier versions, keep the full-column view as the default. See Formulas and Column Visibility.

Verify Formula Configuration

Confirm your formula columns are properly configured in sheet configuration:

columns:
  - id: rpn
    header: RPN
    bindings: rpn
    formula: commonRpn
    readOnly: true
formulas:
  commonRpn: "function(info){ var value = info.item['occ']*info.item['det']*info.item['sev']; return value?value:null;}"

Key points to verify:

Property	Expected Value	Notes
`formula`	References a key in `formulas`	Must match exactly
`readOnly`	`true` (auto-set for formula columns)	Formula columns are read-only by default
`visible`	Any value	Does not affect execution (v26.7.1 and later); controls only whether the column appears in the grid and in exports
`readOnly`	`false` if the value must be stored	Required for the calculated value to reach the bound Polarion field and OData exports

Check Export Column Types

Different column types produce different output formats. Verify that your formula column values match the expected export format:

Column Type	Excel Output	PDF Output
Numeric formulas (RPN, scores)	Number values	Formatted numbers
String formulas	Plain text	Plain text
Boolean columns	`true` or `false` text	`true` or `false` text
Multi-enum columns	Comma-separated display names	Comma-separated display names
Item link columns	Plain text (HTML stripped)	Label text
Server-rendered columns	Plain text with line breaks	Plain text (HTML stripped)

Verification

After applying the resolution:

Open the Risksheet document and verify calculated columns display correct values in the grid
Export to Excel and confirm the formula column values appear in the exported file
Check both imported items and manually edited items to ensure consistent values

You should now see all calculated column values correctly populated in both Excel and PDF exports, including items that were originally imported via scripts or bulk operations.

FAQ

Calculated Columns Missing in Exports

Symptoms

Fix: Sync Formula Values (v24.5.1+)

Fix: Formula Column Missing from the Export

Verify Formula Configuration

Check Export Column Types

Verification

See Also

​Symptoms

​Fix: Sync Formula Values (v24.5.1+)

​Fix: Formula Column Missing from the Export

​Verify Formula Configuration

​Check Export Column Types

​Verification

​See Also

Symptoms

Fix: Sync Formula Values (v24.5.1+)

Fix: Formula Column Missing from the Export

Verify Formula Configuration

Check Export Column Types

Verification

See Also