The toolbar menu provides primary sheet operations accessible from the top bar of the Powersheet interface.
Item Description Shortcut Add Row Creates a new entity row in the sheet with default values Ctrl+SpaceDelete Row Removes the currently selected row Ctrl+Backspace or Ctrl+DeleteExport to Excel Exports visible sheet content with formatting to XLSX Ctrl+EGroup by Column Groups rows by the selected column values Ctrl+GAdd to Groups Adds selected column to existing grouping hierarchy Ctrl+Alt+GClear Grouping Removes all row grouping Ctrl+Shift+GFreeze Columns Freezes columns to the left of the selection Ctrl+FFreeze to Column Freezes all columns up to and including the selected column Ctrl+Alt+FUnfreeze All Removes all column freezing Ctrl+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:
Condition Effect No cell selected Keyboard shortcuts are disabled Sheet not focused Shortcuts do not fire Read-only mode Add Row and Delete Row are hidden No permissions Configuration editing menu items are hidden
The menu system connects with several Powersheet subsystems:
Subsystem Menu Integration Toolbar Renders primary action buttons with icons Sort and Filter Column sort state reflected in toolbar indicators Review Changes Review mode toggle accessible from toolbar Views Selector View switching available through menu dropdown Search Search input embedded in the toolbar area
When the current user has configuration editing permissions, the menu exposes additional items for managing the sheet configuration and domain model.
Item Description Edit Config Opens the YAML configuration editor for the current sheet Open Model Opens the domain model editor for the referenced model Refresh Reloads 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:
Permission Menu Items Shown readOnlyView-only items (Export, Search, Filter) Standard edit All data manipulation items (Add, Delete, Edit, Link) Admin Configuration 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.
The linking mode is a specialized menu interaction for creating relationships between work items:
Step Action 1 Select a source cell in a many-to-many relationship column 2 Enter linking mode from the toolbar 3 Valid link targets are highlighted with a green marquee 4 Click 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.
Related Pages
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