Calculated Columns Missing in Exports

Symptoms

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

Items 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.

Starting 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: Formulas Not Executing for Hidden Columns

Formulas only execute when their column is visible in the sheet. If a formula column is hidden, its value is not calculated and will not appear in exports.

Check if the formula column is hidden in your current view
Use saved views rather than hidden columns for export-specific layouts
Ensure the formula column is visible when the sheet loads

{
  "views": [
    {
      "name": "Export View",
      "columns": ["id", "title", "severity", "occurrence", "rpn", "rpnNew"]
    },
    {
      "name": "Editing View",
      "columns": ["id", "title", "severity", "occurrence", "detection", "rpn", "mitigation", "rpnNew"]
    }
  ]
}

Do not set an export-specific saved view as the default view. Formulas run on sheet load, and a restricted column set may prevent dependent formulas from executing. Keep the full-column view as the default.

Verify Formula Configuration

Confirm your formula columns are properly configured in risksheet.json:

{
  "columns": [
    {
      "id": "rpn",
      "header": "RPN",
      "binding": "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`	Must be `true` at sheet load time	Hidden formula columns do not execute

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.

​Symptoms

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

​Fix: Formulas Not Executing for Hidden Columns

​Verify Formula Configuration

​Check Export Column Types

​Verification

​See Also

Symptoms

Fix: Sync Formula Values (v24.5.1+)

Fix: Formulas Not Executing for Hidden Columns

Verify Formula Configuration

Check Export Column Types

Verification

See Also