Sort and Filter Overview
Column Sorting
Interactive Sorting
| Action | Behavior |
|---|
| Click column header sort icon | Sorts by that column. Toggles between ascending and descending. |
Ctrl+Click column header | Adds column to existing multi-column sort criteria |
| Click already-sorted column | Toggles between ascending and descending direction |
Sort State Indicators
| Indicator | Meaning |
|---|
| Arrow up | Column sorted ascending |
| Arrow down | Column sorted descending |
| Small number on header | Position in multi-column sort (1, 2, 3…) |
Default Sort Configuration
Default sort order is defined in the sortBy section of the sheet configuration:
sortBy:
- columnId: outlineNumber
direction: asc
| Property | Type | Default | Description |
|---|
columnId | string | (required) | Dot-separated binding path to the column |
direction | string | "asc" | Sort direction: "asc" (ascending) or "desc" (descending) |
The default sort from the configuration is always re-applied after the user sorts interactively. This maintains hierarchical ordering stability.
Sort Behavior by Column Type
| Column Type | Sort Key |
|---|
| Text | Alphabetical (lexicographic) |
| Enum | By enum value sequence order (not alphabetical) |
| Reference | By the display value of the referenced entity |
| Custom renderer | By the rendered display text |
| Workflow | By transition name or state value |
| Formatted number | By display text (e.g., $11,066 sorted as string) |
Multiple sortBy entries are supported. The first entry is the primary sort; subsequent entries break ties.
Column Filtering
Filter Panel
Each column header exposes a filter panel with:
| Feature | Description |
|---|
| Value list | Checkbox list of distinct values in the column |
| Condition filters | Comparison-based conditions (contains, equals, etc.) |
| Instant apply | Filters update immediately on checkbox change |
| Clear button | Resets the filter for the current column |
Filter Commands
| Command | Description |
|---|
filter | Applies a column-based filter to show a subset of rows |
filterClear | Clears the filter for a specific column |
filterClearAll | Removes all active filters, restoring all rows |
Filtered Row Count
When filters are active, the toolbar displays a row count indicator:
- X = visible rows after all filters (including search)
- Y = total rows passing column filters (before search)
This indicator is hidden when all rows are visible.
Filter Behavior by Column Type
| Column Type | Filter Behavior |
|---|
| Enum columns | Ordered by enum definition sequence |
| Reference columns | Filterable by display value with checkbox selection |
| Server-rendered columns | Custom filter rendering for rendered values |
| Text columns | Standard value list and condition filters |
Combining Sort and Filter
Sorting and filtering operate independently and can be combined:
- Filters reduce the visible row set
- Sorting orders the filtered rows
- Search further narrows filtered results
- Review mode can be layered on top of filters
The filtered rows indicator reflects the combined effect of all active operations.
Row Grouping
Row grouping provides another dimension of data organization through collapsible group headers:
| Action | Shortcut | Description |
|---|
| Group by column | Ctrl+G | Groups rows by the selected column |
| Add to groups | Ctrl+Alt+G | Adds column to existing multi-level grouping |
| Clear grouping | Ctrl+Shift+G | Removes all grouping |
Grouping via Configuration
Columns can be pre-configured for grouping using the groupBy property:
columns:
severity:
title: Severity
groupBy: true
Complete YAML Example
sortBy:
- columnId: outlineNumber
direction: asc
- columnId: priority
direction: desc
columns:
outlineNumber:
title: "#"
width: 60
sort: asc
title:
title: Title
width: "*"
hasFocus: true
severity:
title: Severity
width: 120
groupBy: true
systemRequirements.systemRequirement.title:
title: System Requirement
width: 200
Related Pages
- Sort By —
sortBy configuration reference
- Columns — column property reference including
sort and groupBy
- Search — text search across sorted/filtered data
- Review Changes — review mode filtering
- Toolbar — sort and filter indicators in the toolbar
Source: sortBy Configuration Guide KB article, sorting and filtering test specifications, sheet component features
KB ArticlesSource Code
prod-powersheet-src/com.nextedy.powersheet.client/ltc-repo/cypress/e2e/Sheet/sorting.spec.tsprod-powersheet-src/com.nextedy.powersheet.client/ltc-repo/packages/sheet/SheetComponent.tsxmodel.yamlprod-powersheet-src/com.nextedy.powersheet.client/ltc-repo/cypress/e2e/Sheet/reference.spec.tsprod-powersheet-src/com.nextedy.powersheet.client/ltc-repo/packages/sheet/ViewModel.ts
