Skip to main content

​
Set a Fixed Pixel Width

Assign a number to the width property to set the column width in pixels: 
columns:
  id:
    width: 80
  description:
    title: "Foreseeable Sequence of Events"
    width: 140
This sets the id column to exactly 80 pixels and the description column to 140 pixels.

​
Set a Proportional Width

Use a string with * to define proportional width relative to other star-sized columns. The available space (after fixed-width columns are allocated) is distributed proportionally: 
columns:
  id:
    width: 80
  title:
    width: "*"
  description:
    width: "2*"
In this example, after the id column takes 80 pixels, the remaining space is split — title gets one share and description gets two shares.
Width ValueTypeBehavior
80NumberFixed width of 80 pixels
"*"StringOne proportional share of remaining space
"2*"StringTwo proportional shares of remaining space
If width is not specified, the default value is "*" — the column takes one proportional share of the available space.

​
Set a Minimum Width

Use minWidth to prevent a column from shrinking below a certain pixel threshold when the sheet is resized: 
columns:
  validationTestCases.validationTestCase:
    title: Validation Test Cases
    minWidth: 200
The default minWidth is 150 pixels. This prevents narrow columns from making content unreadable when many columns are displayed simultaneously.

​
Width Strategy Decision Guide

diagram
Use fixed pixel widths for narrow identifier columns (id, outlineNumber), proportional "*" for content-heavy columns (title, description), and minWidth for collection columns that need guaranteed minimum space.

​
Complete Example

columns:
  outlineNumber:
    title: "#"
    width: 80
    isreadOnly: true
  title:
    title: Title
    width: "*"
    hasFocus: true
  description:
    title: Description
    width: "2*"
  systemRequirements.systemRequirement.title:
    title: System Requirement
    width: 180
    minWidth: 150
  validationTestCases.validationTestCase:
    title: Validation
    width: "*"
    minWidth: 200
    multiItem: true

​
Verify

After saving the sheet configuration, reload the powersheet document. You should now see columns displayed with the widths you configured — fixed-width columns maintaining their exact pixel size and star-sized columns filling the remaining space proportionally.

​
See also

KB ArticlesSource Code
  • prod-powersheet-src/com.nextedy.powersheet.client/cypress/fixtures/configurations/constraints_currentDocument_downstream.template.yaml
  • powersheet.yaml
  • prod-powersheet-src/com.nextedy.powersheet.client/ltc-repo/packages/common/types/api/document.ts
  • prod-powersheet-src/com.nextedy.powersheet.client/cypress/fixtures/configurations/whole_rtm.template.yaml
  • prod-powersheet-src/com.nextedy.powersheet.client/src/modules/ConfigProvider/types/PowersheetConfig.d.ts