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: truein the data model (the default)
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:To inspect a row in Polarion’s native work item form, use the Open in form action (
) on the work items tree. The Polarion form opens in a new tab, leaving your unsaved changes in the sheet intact.
| Field Type | Editor Behavior |
|---|---|
| Text / String | Inline text input |
| Enum | Dropdown with available options |
| Integer / Float / Currency | Numeric input |
| Reference (navigation property) | Picker with search |
| Read-only / Calculated | No editing allowed (cursor changes) |
Fields marked with
updatable: false in the data model, system fields like id and outlineNumber, and server-rendered properties cannot be edited. The cell will not enter edit mode when clicked.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.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
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.
Save Changes
Click Save to persist all pending changes. The save operation:
- Validates all modified entities
- Saves entities one by one in dependency order
- Clears the undo stack on success
- Restores the sheet to its normal editing state
See Also
- Create a Work Item — add new work items to the sheet
- Handle Validation Errors — resolve errors that occur during save
- Set Entity Permissions — control field-level
readableandupdatablesettings - Configure Read-Only Column — make specific columns non-editable