PivotColRole
type PivotColRole = { col: number; kind: "subheading" | "subtotal"; level?: number;};The style role of one pivot output column that styles differently from a plain data column,
identified by its 0-based column offset from the left of the pivot’s ref --- the column-axis
mirror of PivotRowRole:
subheading: a column-axis group label column.subtotal: a column-axis subtotal column.
The region paints the whole column as a vertical strip (header rows and body rows alike),
layering over the header/stripe composition property by property: its fill wins, but a bold from
the header band is kept (Excel-verified for firstSubtotalColumn on PivotStyleLight16).
Properties
Section titled “Properties”| Property | Type | Description |
|---|---|---|
col | number | - |
kind | "subheading" | "subtotal" | - |
level? | number | 1-based column-field nesting level (1 = outermost), selecting the dxf tier --- see PivotRowRole.level. Column subtotals have only a first* dxf, so level affects only column subheadings. Defaults to level 1 when absent. |