Perform Bulk Editing

​

Select Multiple Cells

To perform bulk operations, first select the target cells:

1. Click a cell to select it as the starting point
2. Hold Ctrl (or Cmd on macOS) and click additional cells to add them to the selection
3. Alternatively, click the first cell, then Shift+Click the last cell in a range to select a contiguous block

​

Copy Values to Multiple Cells

The most efficient bulk editing technique is copy-paste across selected cells:

1. Select the source cell containing the value you want to replicate
2. Press Ctrl+C to copy the cell value
3. Select all target cells where you want to paste the value (using Ctrl+Click or Shift+Click)
4. Press Ctrl+V to paste the value into all selected cells

​

Bulk Edit with Cascading Updates

When you edit an enumeration field across multiple selected rows, Risksheet automatically propagates dependent enumeration updates to all selected items. This keeps data consistent across bulk operations. Example: Changing the Risk Category from “Mechanical” to “Electrical” on three selected rows simultaneously updates each row’s Risk Type options according to configured relationship mappings.

​

How It Works

1. Select multiple rows by clicking row headers while holding Ctrl or Shift
2. Edit a parent enumeration field (e.g., severity) on any of the selected rows
3. Risksheet applies the new value to all selected rows
4. Dependent child columns update automatically based on the configured relations mappings

​

Keyboard Shortcuts for Bulk Operations

​

Autocomplete for Consistent Data Entry

When editing text or link columns across multiple rows, Risksheet provides autocomplete suggestions to speed up data entry and maintain consistency:

• Text fields: As you type, existing values from the same column are suggested for consistency across risk items
• Link columns: Type a work item ID or title to search, or click the dropdown arrow to browse available items
• New item creation: For link columns with canCreate enabled, type a new value and select Add new <type> to create and link a new work item inline

Autocomplete includes unsaved local changes, so you can reference items created earlier in the same session before saving to the server.

​

Verify Your Bulk Edit

After performing bulk edits:

1. Review the modified cells — changed values appear with a visual indicator until saved
2. Check that dependent enum columns updated correctly on all edited rows
3. Save the document to persist changes to Polarion

You should now see all bulk-edited values saved, with dependent fields correctly reflecting the cascading relationship rules.

​

See Also

• Configure Dependent Enums — set up cascading relationships between columns
• Configure Multi-Select Enums — enable multi-value selection on enum columns
• Use Undo and Redo — revert bulk operations
• Configure Calculated Columns — formulas that recalculate after bulk edits

Sources

Support Tickets

• #5848

Source Code

• RelationActionController.ts
• TextEditor.ts