Skip to main content

Prerequisites

  • A Powersheet document open in Siemens Polarion ALM with a valid sheet configuration and data model
  • The entity type you want to create must be defined in the data model with a valid polarionType mapping
  • Your user account must have create permissions (isCreatable enabled) for the target work item type
1

Add a New Row

Click the Add button (Plus-in-circle icon used as the Add button in the Powersheet work items tree toolbar) in the sheet toolbar. A new empty row appears in the sheet with default values from the entity factory configuration.
diagram
The new row is created at the current hierarchy level. If you have a multi-level sheet (for example, UserNeed > SystemRequirement > DesignRequirement), the row is added at the level corresponding to the selected cell’s entity type.
2

Enter Required Fields

Click into the new row and type directly into cells to populate field values. The cell that receives initial focus is determined by the hasFocus property in your sheet configuration:
Press Enter to commit the cell edit. Fields configured as isReadOnly: true or with updatable: false in the data model cannot be edited.
Powersheet supports saving several custom field types including integer fields (c_intField), floating-point fields (c_floatField), and currency fields (c_currencyField). Each field type tracks both the current value and the original value for change detection.
3

Understand Document Routing

When your data model defines constraints on the entity type, new work items are automatically routed to the correct Polarion document. The constraint system scopes new entities to the current document context automatically.For example, a data model that routes SystemRequirement items to a specific document:
When a user creates a SystemRequirement, it is automatically placed in the document matching the specified folder, name, and type.
The constraint system can route new items based on the source entity’s document context. This is useful when the same entity type should go to different documents depending on where it was created from within the expansion path.

Constrained Picker Values

In a multi-level sheet, constraints can also filter the available values in picker columns. For example, when creating a UserNeed and selecting a linked SystemRequirement, the picker shows only system requirements from the matching document type.
4

Review Before Saving

Before saving, use review mode to inspect your pending changes:
  1. The Review toggle appears automatically in the toolbar when any changes exist
  2. Click it to filter the sheet to show only rows with pending changes
  3. New rows are indicated with the Added state marker on the row header
  4. Use the review mode dropdown menu to filter by change type
The row count display shows the format N/M rows where N is the number of visible filtered rows and M is the total row count.
Adding a row without entering any data does not enable the Save button. Only actual data changes (typing values into cells) mark the row as dirty. If you add a row and then undo, the sheet returns to its original clean state.
5

Save Changes

Click the Save button (💾) in the toolbar. During the save operation:
  1. The sheet checks for any active error state — if errors exist, you see an alert message and the save is blocked
  2. The sheet temporarily enters read-only mode to prevent concurrent edits
  3. All pending entity changes (with Added state) are validated and sent to the server
  4. Server-generated identifiers (such as objectId) are assigned to new items via key mapping
  5. The undo stack is cleared on successful save
  6. Original read-only state and permissions (isCreatable, isDeletable, isUpdatable) are restored
If the sheet is in an error state, the save operation is blocked with the message: “There is an error in the app and save should not happen. Please, reload the browser.” Resolve any errors or reload the page before attempting to save again.
6

Undo and Redo

If you make a mistake before saving, use the Undo () and Redo () buttons in the toolbar:
  • Undo reverses the last operation (add, remove, or edit) and restores the previous sheet state including row position and content
  • Redo re-applies a previously undone operation
  • Both operations preserve selection state, including multi-row selections
  • Undoing all operations disables both the Undo and Save buttons
Select multiple rows using Shift+Click (click the first row, hold Shift, click the last row). You can then remove all selected rows at once with the Remove button. This operation is fully undoable.
7

Verify

You should now see the new work item in the sheet with a server-assigned ID. The row header no longer shows the Added state indicator, and the Save button is disabled (indicating no pending changes remain).
Open the corresponding Polarion LiveDoc to confirm the work item appears in the expected document location with the correct work item type. If document routing constraints are configured, verify the item was placed in the correct module folder.

Troubleshooting

See Also

Last modified on July 10, 2026