AxisFieldPatch
subtotals is the automatic subtotal; functions the custom ones, which turn it off.
Import from @reductoai/xlsx/editor.
AxisFieldSettings
Import from @reductoai/xlsx/editor.
Pivot
Not exported by name. You get it from the API.
PivotCalcFieldSettings
What the Insert Calculated Field window lists: every field, and the formulas of the calculated ones.
Import from @reductoai/xlsx/editor.
PivotCalcItemCommand
Import from @reductoai/xlsx/editor.
PivotCalcItemSettings
What the Insert Calculated Item window shows for the field under the active cell.
Import from @reductoai/xlsx/editor.
PivotDrill
A +/- button on a pivot item label, 1-based; item is the shared item index, x the box’s offset from the cell’s left edge.
Not exported by name. You get it from the API.
PivotFilterArrow
Not exported by name. You get it from the API.
PivotFilterAxis
Not exported by name. You get it from the API.
PivotGroupingSettings
The Grouping window: label is the field clicked, field the source field it groups.
Import from @reductoai/xlsx/editor.
PivotLine
One body line; key holds an item per field from the outermost, subtotals leave out Values.
Not exported by name. You get it from the API.
PivotLook
A pivot’s style, its options and the shape of its body, offsets 0-based inside range.
Not exported by name. You get it from the API.
PivotMoveSettings
What the Move PivotTable window starts with: the table’s first cell, “Sheet1!3”.
Import from @reductoai/xlsx/editor.
PivotOptionsPatch
The boxes of Windows Excel’s PivotTable Options, named as the facade names them.
Import from @reductoai/xlsx/editor.
PivotOptionsSettings
Import from @reductoai/xlsx/editor.
PivotSolveOrderSettings
The Solve Order window’s list, first solved first.
Import from @reductoai/xlsx/editor.
PivotSourceSettings
What the Change PivotTable Data Source window starts with.
Import from @reductoai/xlsx/editor.
SlicerConnection
A row of Report Connections: a pivot table on the slicer’s pivot cache.
Import from @reductoai/xlsx/editor.
SlicerPatch
What Slicer Settings and the Slicer tab change; sizes in points.
Import from @reductoai/xlsx/editor.
SlicerSettings
A slicer as Slicer Settings shows it.
Import from @reductoai/xlsx/editor.
SubtotalFn
Subtotal’s “Use function” list, in Excel’s order.
Import from @reductoai/xlsx/editor.
SubtotalFunctionKey
A custom subtotal function, by its Excel.Subtotals key.
Import from @reductoai/xlsx/editor.
SubtotalGuess
Subtotal’s dialog: the list it works on and its header labels by sheet column.
Import from @reductoai/xlsx/editor.
ValueFieldPatch
Import from @reductoai/xlsx/editor.
ValueFieldSettings
A value field as Value Field Settings shows it, with the fields and items Show Values As offers.
Import from @reductoai/xlsx/editor.
ValueShowAs
A value field’s Show Values As, by field and item name; “(previous)” and “(next)” are items too.
Import from @reductoai/xlsx/editor.