Skip to main content

​
Column Organization Layers

diagram

​
Column Groups

Column groups visually organize related columns under a shared header with color-coded styling and optional collapse behavior. See Column Groups for full configuration reference.

​
Column Group Properties

PropertyTypeDefaultDescription
groupNamestring(required)Display name for the column group header
groupStylestringSee applicationColor theme for the column group background
headerStylestringSee applicationColor theme for the column group header text
collapseTostringSee applicationDot-notation binding path to the column shown when the group is collapsed

​
Column Group Example

columnGroups:
  requirements:
    groupName: Requirements
    groupStyle: blue
    headerStyle: darkBlue
    collapseTo: systemRequirements.systemRequirement.title

  hazards:
    groupName: Hazards
    groupStyle: orange
    headerStyle: darkOrange
    collapseTo: hazards.hazard.title
Assign a column to a group using the columnGroup property: 
columns:
  systemRequirements.systemRequirement.title:
    title: System Requirement
    columnGroup: requirements
  systemRequirements.systemRequirement.severity:
    title: Severity
    columnGroup: requirements
  hazards.hazard.title:
    title: Hazard
    columnGroup: hazards

​
Column Visibility

Each column has a visible property controlling its default display state:
PropertyTypeDefaultDescription
visiblebooleantrueControls whether the column is shown by default

​
Views Override Visibility

Views override column visibility settings. When a view is applied, its column definitions take precedence over the default visible property. 
views:
  Without V&V:
    columns:
      validationTestCases.validationTestCase:
        visible: false
      verificationTestCases.verificationTestCase:
        visible: false
See Views Selector for the runtime view switching interface.

​
Column Configuration Properties

Each column in the columns section supports these display-related properties:
PropertyTypeDefaultDescription
titlestringBinding pathDisplay label for the column header
widthnumber or string"*"Width in pixels or proportional (e.g., "*", "2*")
minWidthnumber150Minimum column width in pixels
visiblebooleantrueWhether the column is shown by default
hasFocusbooleanfalseWhether this column receives initial focus
columnGroupstringSee applicationAssigns the column to a visual group
formatterstringSee applicationReferences a formatter for conditional styling
headerobjectSee applicationColumn header appearance settings
groupBybooleanfalseEnables row grouping by this column’s values
sortstringSee applicationDefault sort direction for this column
multiItembooleanfalseDisplays multiple related items (one-to-many)
displaystringSee applicationProperty of a referenced object to display
isReadOnlybooleanfalsePrevents user editing (deprecated; use formatter: readOnly)
For full column property details, see Column Properties.

​
Column Freezing

Columns can be frozen (pinned) to remain visible during horizontal scrolling:
ActionShortcutDescription
Freeze columnsCtrl+FFreezes columns at the default position
Freeze to columnCtrl+Alt+FFreezes all columns up to and including the selected column
Unfreeze allCtrl+Shift+FRemoves all column freezing
The frozen property in the column configuration sets the default frozen state.

​
Column Width Types

TypeSyntaxExampleBehavior
Fixednumberwidth: 120Fixed width in pixels
Proportional"*"width: "*"Shares remaining space equally with other * columns
Weighted proportional"N*"width: "2*"Takes N times the proportional share

​
Complete YAML Example

columnGroups:
  userNeeds:
    groupName: User Needs
    groupStyle: blue
    headerStyle: darkBlue
    collapseTo: title
  sysReqs:
    groupName: System Requirements
    groupStyle: green
    headerStyle: darkGreen
    collapseTo: systemRequirements.systemRequirement.title

sortBy:
  - columnId: outlineNumber
    direction: asc

columns:
  outlineNumber:
    title: "#"
    width: 60
    sort: asc
  title:
    title: Title
    width: "*"
    hasFocus: true
    columnGroup: userNeeds
  severity:
    title: Severity
    width: 100
    columnGroup: userNeeds
  systemRequirements.systemRequirement.title:
    title: Sys Req Title
    width: 200
    columnGroup: sysReqs
  systemRequirements.systemRequirement.severity:
    title: Sys Req Severity
    width: 120
    columnGroup: sysReqs
    visible: false

views:
  All Columns:
    columns:
      systemRequirements.systemRequirement.severity:
        visible: true
  Compact:
    columns:
      severity:
        visible: false
      systemRequirements.systemRequirement.severity:
        visible: false
Source: Column Configuration Guide KB article, Views Configuration Guide KB article, sheet configuration YAML, ViewModel features
KB ArticlesSource Code
  • prod-powersheet-src/com.nextedy.powersheet.client/ltc-repo/packages/sheet/RowItemFactory.ts
  • prod-powersheet-src/com.nextedy.powersheet.client/ltc-repo/packages/sheet/ViewModel.ts
  • prod-powersheet-src/com.nextedy.powersheet.client/ltc-repo/packages/common/types/api/document.ts
  • prod-powersheet-src/com.nextedy.powersheet.client/ltc-repo/__tests__/test-viewModel.ts
  • powersheet.yaml