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. |