Skip to main content
diagram

Toolbar Menu Items

The toolbar menu provides primary sheet operations accessible from the top bar of the Powersheet interface.
ItemDescriptionShortcut
Add RowCreates a new entity row in the sheet with default valuesCtrl+Space
Delete RowRemoves the currently selected rowCtrl+Backspace or Ctrl+Delete
Export to ExcelExports visible sheet content with formatting to XLSXCtrl+E
Group by ColumnGroups rows by the selected column valuesCtrl+G
Add to GroupsAdds selected column to existing grouping hierarchyCtrl+Alt+G
Clear GroupingRemoves all row groupingCtrl+Shift+G
Freeze ColumnsFreezes columns to the left of the selectionCtrl+F
Freeze to ColumnFreezes all columns up to and including the selected columnCtrl+Alt+F
Unfreeze AllRemoves all column freezingCtrl+Shift+F
Keyboard shortcuts use Ctrl on Windows/Linux and Cmd on macOS. Powersheet automatically detects the platform.

Context-Aware Behavior

Menu item availability depends on the current application state:
ConditionEffect
No cell selectedKeyboard shortcuts are disabled
Sheet not focusedShortcuts do not fire
Read-only modeAdd Row and Delete Row are hidden
No permissionsConfiguration editing menu items are hidden
The menu system connects with several Powersheet subsystems:
SubsystemMenu Integration
ToolbarRenders primary action buttons with icons
Sort and FilterColumn sort state reflected in toolbar indicators
Review ChangesReview mode toggle accessible from toolbar
Views SelectorView switching available through menu dropdown
SearchSearch input embedded in the toolbar area

Configuration Menu

When the current user has configuration editing permissions, the menu exposes additional items for managing the sheet configuration and domain model.
ItemDescription
Edit ConfigOpens the YAML configuration editor for the current sheet
Open ModelOpens the domain model editor for the referenced model
RefreshReloads data from the server
The exact set of configuration menu items may vary depending on your Powersheet version and license level.

Permission-Based Visibility

Menu items are displayed or hidden based on the user’s permissions for the current document and model:
PermissionMenu Items Shown
readOnlyView-only items (Export, Search, Filter)
Standard editAll data manipulation items (Add, Delete, Edit, Link)
AdminConfiguration editing items (Edit Config, Open Model)
The readOnly state is determined by three factors: the isReadOnly flag in the sheet configuration, whether the user is viewing a historical revision, or whether the user has only read-only permissions on the document.

Linking Mode Menu

The linking mode is a specialized menu interaction for creating relationships between work items:
StepAction
1Select a source cell in a many-to-many relationship column
2Enter linking mode from the toolbar
3Valid link targets are highlighted with a green marquee
4Click a target cell to create the link
Linking mode only works with many-to-many relationships defined in the domain model. Self-referencing and duplicate links are prevented automatically.

Source: Powersheet configuration context, sheet component features
Source Code
  • prod-powersheet-src/com.nextedy.powersheet.client/src/modules/Powersheet/Powersheet.tsx
  • configContext.ts
  • prod-powersheet-src/com.nextedy.powersheet.client/ltc-repo/packages/sheet/SheetComponent.tsx
  • model.yaml