Skip to main content

​
Verify Data Synchronization (v24.5.1+)

Nextedy RISKSHEET version 24.5.1 introduced automatic data synchronization between calculated formula values and Polarion work item fields. If you’re running an earlier version, upgrade to 24.5.1 or later to enable persistent calculated values in exports. Check your RISKSHEET version:
  1. Open your RISKSHEET widget
  2. Look for the version number in the bottom status bar or top panel
  3. If version is below 24.5.1, contact your administrator to schedule an update
Before v24.5.1, calculated column values only displayed in the RISKSHEET UI but were not reliably persisted to Polarion work items. This caused exports to show blank cells or inconsistent values, especially for work items imported from external sources without saving calculated fields.

​
Common Causes and Solutions

​
Imported Data Without Saved Values

When migrating data to Polarion, if calculated field values are not explicitly saved during import, formulas execute in the RISKSHEET UI but values don’t persist to the underlying work item fields. Solution: diagram
  1. Open the RISKSHEET containing imported work items
  2. Wait for all formulas to calculate (watch the status bar for completion)
  3. Select all rows (Ctrl+A)
  4. Click 💾 Save to persist calculated values to Polarion
  5. Verify that values persist by refreshing the page
  6. Retry the export operation
For risksheets with hundreds of items, save in batches of 50-100 rows to avoid timeout errors. Select row ranges using Shift+Click, save, then continue with the next batch.

​
Enumeration Field Formulas

Formulas referencing enumeration fields must use option IDs (internal identifiers) rather than display names. Incorrect (uses display name): 
function(info) {
  if (info.item['status'] === 'Acceptable') {
    return 'Low';
  }
  return 'High';
}
Correct (uses option ID): 
function(info) {
  if (info.item['status'] === 'acceptable') {  // lowercase ID
    return 'Low';
  }
  return 'High';
}
To find enum option IDs:
  1. Navigate to Administration → Work Items → Enumerations
  2. Select the enumeration (e.g., Risk Status)
  3. Note the ID column values (not the Name column)
  4. Update your formulas to reference these IDs

​
Browser-Specific Export Issues

Firefox versions prior to 24.5.1 may fail to trigger Excel export buttons. Solution:
  1. Try exporting using Chrome, Edge, or Safari
  2. If Firefox is required, upgrade RISKSHEET to v24.5.1+ which includes Firefox export fixes
  3. Check browser console (F12) for JavaScript errors during export attempts

​
Hidden Columns with Formulas

Calculated columns hidden via saved views or column visibility settings may not evaluate during export. Solution:
  1. Navigate to View → Column Visibility
  2. Temporarily show all calculated columns
  3. Wait for formulas to execute (status bar shows “Ready”)
  4. Save the RISKSHEET
  5. Perform the export
  6. Re-apply your saved view to hide columns
See Work with Formulas and Hidden Columns for configuration guidance.

​
Verify Export Results

After applying fixes:
  1. Export the RISKSHEET to Excel
  2. Open the Excel file
  3. Verify that calculated columns contain values for all rows
  4. Compare several values against the RISKSHEET UI to confirm consistency
  5. Repeat export 2-3 times to verify values remain stable between exports
You should now see consistent calculated column values in all exports, matching the values displayed in the RISKSHEET interface.

​
See also

Support TicketsSource Code
  • ExportToExcel.ts
  • ExportToPdf.ts
  • PolarionAppConfigManager.java
  • AppConfigHelper.ts
  • AppConfig.ts