Skip to main content

​
Prerequisites

  • A powersheet document with pending changes that you are attempting to save
  • Familiarity with the review mode toolbar controls

​
Step 1: Identify the Error

When a save operation encounters validation errors, Powersheet collects all errors across all entities and presents them as a single aggregated error message. The sheet does not lose your changes — all pending modifications remain in place for correction. Errors fall into two categories:
Error TypeBehaviorRecovery
Entity validation errorCollected per entity, reported after all saves completeFix the data and retry save
Application errorSave is interrupted immediatelyReload the browser
If an application-level error occurs (such as a server timeout or connectivity issue), the save process stops immediately. Entity validation errors, by contrast, are collected for all entities and reported together after the save cycle completes.

​
Step 2: Enter Review Mode

After a failed save, the review mode remains active. Use it to locate problematic rows:
  1. Click the Review toggle if it is not already active
  2. Open the review filter menu and select Problems to filter to rows with validation errors
  3. The row count display shows how many rows have issues (e.g., “2/45 rows”)
diagram

​
Step 3: Inspect Problem Rows

Rows with validation errors display both the modified and error visual indicators on the row header. The review filter menu shows the count of problem rows (e.g., “Problem rows: 2”). Individual cells contributing to errors may also show a modified state indicator. Check the following common causes:
  • Missing required fields — a required Polarion field has no value
  • Invalid enum value — the selected value is not in the allowed options for the work item type
  • Constraint violations — the entity does not match the document routing constraints
  • Workflow state conflicts — attempting a workflow transition on an unsaved entity
Workflow transitions require the entity to be persisted first. If you attempt a transition on a newly created (unsaved) work item, you will receive a validation error. Save the entity first, then apply the workflow transition.

​
Step 4: Correct the Data

Edit the problematic cells directly in the sheet:
  1. Click into the cell with the error
  2. Enter a valid value
  3. The error indicator should clear when you commit the edit
If you cannot determine the correct value, use Ctrl+Z to undo the change and restore the original value. You can then re-attempt the edit with the correct data.

​
Step 5: Retry the Save

After correcting all validation errors, click Save again. Entities are saved in topologically sorted order (parents before dependents) to prevent foreign key violations.
If the sheet entered an error state during the previous save attempt, you may see a blocking message: “There is an error in the app and save should not happen. Please, reload the browser.” In this case, reload the page. Your unsaved changes may need to be re-entered.

​
Step 6: Verify

You should now see all rows saved successfully. The review mode toggle disappears when no pending changes remain. The Save button is disabled, and row headers show no modification or error indicators.

​
See Also

Source Code
  • prod-powersheet-src/com.nextedy.powersheet.client/src/modules/ModelProvider/ModelProvider.tsx
  • SaveTest.java
  • prod-powersheet-src/com.nextedy.powersheet.client/ltc-repo/packages/sheet/commands/save.ts
  • prod-powersheet-src/com.nextedy.powersheet.client/ltc-repo/__tests__/test-saveManager.ts
  • prod-powersheet-src/com.nextedy.powersheet.client/ltc-repo/cypress/e2e/Sheet/review-mode.spec.ts