PivotPageArea
type PivotPageArea = object;Geometry of a pivot’s page-field (report filter) area. The area sits above the pivot’s output
area, OUTSIDE ref --- Excel’s location/@ref convention excludes it --- so its row offsets,
relative to the top of ref, are negative. Each page field is a caption / selected-item cell
pair; the fields fill a grid rowCount rows tall by colCount column-groups wide, ending one
blank spacer row above the output area (so the last row is at ref-relative row -2).
The grid is a single column by default (pageWrap 0); Excel wraps it when pageWrap is set.
Adjacent column-groups are colStride columns apart (Excel uses 3: caption, value, one gap).
Fields are assigned to cells in pageFields order, either down-then-over (default) or
over-then-down (overThenDown); use pageFieldCellOffset to map a field index to its
ref-relative cell. (A partial final group/row is expected when the field count is not a multiple
of the wrap.) All verified in Excel.
Properties
Section titled “Properties”colCount
Section titled “colCount”colCount: number;colStride
Section titled “colStride”colStride: number;firstRow
Section titled “firstRow”firstRow: number;Ref-relative row offset of the first (top) page-field row (-(rowCount + 1)).
labelCol
Section titled “labelCol”labelCol: number;overThenDown
Section titled “overThenDown”overThenDown: boolean;rowCount
Section titled “rowCount”rowCount: number;valueCol
Section titled “valueCol”valueCol: number;