Skip to main content

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!FF3”. 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.

ViewSlicer

A slicer as it paints: the frame drawing of the same name carries its place and size. Not exported by name. You get it from the API.