Skip to main content

​
Column Setup

Add a Column — Define columns in your sheet configuration using binding paths to entity properties Configure Column Width — Set pixel or proportional widths and minimum width constraints Configure a Column Group — Organize related columns under collapsible group headers with shared styling Configure Collapsible Groups — Enable collapse/expand behavior for column groups Add External Reference Column — Display external reference work items linked through relationships Configure Multi-Item Column — Show and edit one-to-many or many-to-many relationships in a single column Configure Read-Only Column — Prevent user editing on specific columns

​
Display and Formatting

Apply Column Styles — Use predefined or custom styles for column headers and cells Configure a Formatter — Apply conditional formatting rules with expressions and styles Configure Conditional Formatting — Highlight cells based on data values using formatter expressions Use JavaScript Display Functions — Render custom HTML in cells using JavaScript arrow functions

​
Views and Layout

Create a View — Define named column visibility presets for switching between different analysis perspectives Set Default Sort Order — Configure default row sorting by column and direction

​
Data Sources and Assignment

Configure Sources — Define data sources, queries, and expansion paths for loading entity hierarchies Assign Configuration to Document — Link a sheet configuration to a Polarion LiveDoc Download Configuration as YAML — Export your current sheet configuration for backup or sharing
Begin with a single entity type, a few columns, and one data source. Extend incrementally — adding column groups, formatters, and views once the basics are working. See Incremental Configuration Approach for guidance.

​
See Also

KB ArticlesSupport TicketsSource Code
  • prod-powersheet-src/com.nextedy.powersheet/src/com/nextedy/powersheet/enumProvider/SheetConfigEnumProvider.java
  • prod-powersheet-src/com.nextedy.powersheet.client/ltc-repo/packages/common/types/api/document.ts
  • prod-powersheet-src/com.nextedy.powersheet.client/src/modules/Powersheet/Powersheet.tsx
  • prod-powersheet-src/com.nextedy.powersheet/src/META-INF/hivemodule.xml
  • prod-powersheet-src/com.nextedy.powersheet.client/cypress/fixtures/configurations/constraints_composing.template.yaml