Skip to main content

​
Prerequisites

  • A powersheet document with loaded data
  • Your user account must have update permissions for the target fields
  • The fields you want to edit must have updatable: true in the domain model (the default)

​
Step 1: Select and Edit a Cell

Click on a cell to select it. Double-click or start typing to enter edit mode. Depending on the field type, you will see one of these editors:
Field TypeEditor Behavior
Text / StringInline text input
EnumDropdown with available options
Integer / Float / CurrencyNumeric input
Reference (navigation property)Picker with search
Read-only / CalculatedNo editing allowed (cursor changes)
Fields marked with updatable: false in the domain model, system fields like id and outlineNumber, and server-rendered properties cannot be edited. The cell will not enter edit mode when clicked.

​
Step 2: Modify Field Values

Type the new value and press Enter to commit the edit. The cell is marked as modified, and the row header shows a visual change indicator. For enum fields, the dropdown automatically filters available options based on the entity context (project, work item type, and enumeration scope). Select the desired option from the list. For reference fields (navigation properties), a picker opens where you can search for related entities by title or ID. 
# Example: Making severity editable in the domain model
domainModelTypes:
  UserNeed:
    polarionType: user_need
    properties:
      severity:
        updatable: true
        readable: true

​
Step 3: Use Undo and Redo

If you make a mistake, use undo and redo to navigate your edit history:
  • Undo: Ctrl+Z — reverts the last change
  • Redo: Ctrl+Y — re-applies the last undone change
The undo stack tracks all operations including cell edits, row additions, and row deletions. Undoing all changes disables the Save button. diagram

​
Step 4: Review Changes

Enable review mode by clicking the review toggle in the toolbar. The sheet filters to display only modified rows. The toolbar shows the count of changed rows (e.g., “Changed rows: 3”). Individual cells that have been modified show a visual indicator, and the row header displays the modification state.

​
Step 5: Save Changes

Click Save to persist all pending changes. The save operation:
  1. Validates all modified entities
  2. Saves entities one by one in dependency order
  3. Clears the undo stack on success
  4. Restores the sheet to its normal editing state
If the sheet has an active error state, the save is blocked with a message: “There is an error in the app and save should not happen. Please, reload the browser.” Reload the page and try again.

​
Step 6: Verify

You should now see the updated values reflected in the sheet. The row headers no longer show the modified indicator, and the Save button is disabled.
You can copy and paste cell values using Ctrl+C and Ctrl+V. Pasting across different hierarchy levels is not supported — the sheet will display a warning if you attempt it.

​
See Also

Source Code
  • prod-powersheet-src/com.nextedy.powersheet.client/ltc-repo/packages/sheet/commands/index.ts
  • 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/packages/sheet/Associations.ts
  • prod-powersheet-src/com.nextedy.powersheet.client/ltc-repo/cypress/e2e/Sheet/add-remove.spec.ts