CalcItemInfo
A calculated item: its field, its name and its formula as the dialog shows it.
Import from @reductoai/xlsx/editor.
FieldSubtotals
Excel.Subtotals: automatic is the field’s default subtotal, the rest are custom ones.
Not exported by name. You get it from the API.
PivotDataField
One data field: its caption, the source field it sums and how.
Import from @reductoai/xlsx.
PivotDataSpec
numFmtId formats the field’s value cells; 0 or absent is General.
Not exported by name. You get it from the API.
PivotFieldFilter
A field’s items in the order the field lists them, and which ones its filter shows.
Not exported by name. You get it from the API.
PivotFilterKind
Not exported by name. You get it from the API.
PivotFlags
Not exported by name. You get it from the API.
PivotGrouping
What the Grouping window shows: the field’s groups, or Excel’s proposal for a field without.
Not exported by name. You get it from the API.
PivotGroupOptions
VBA’s Range.Group: numbers in steps of by, or dates by periods (days in steps of by).
items: labels of a text field to put in one named group instead.
Import from @reductoai/xlsx/officejs.
PivotInfo
A pivot table part, read for display and for the facade; the cells it shows are the sheet’s own.
Import from @reductoai/xlsx.
PivotLayoutType
Import from @reductoai/xlsx.
PivotOptions
Not exported by name. You get it from the API.
PivotSpec
rows and cols may hold VALUES, the Values field, where it sits among the fields.
Not exported by name. You get it from the API.
ShowAsCalc
Not exported by name. You get it from the API.
ShowAsSpec
baseField is a field index; baseItem a position in its <items>, or one of the two above.
Not exported by name. You get it from the API.