Skip to main content

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.