@univerjs-pro/engine-pivot v0.5.0-beta.1Docs


Interface: IPivotTableSnapshot

Represents a snapshot of a pivot table.

Properties

PropertyTypeDescriptionDefined in
collapseInfoRecord<string, any>Represents the collapse information of the pivot table.types/json-types.ts:83
columnFieldsstring[]Represents the fields id used for grouping columns in the pivot table.types/json-types.ts:58
dimensionRecord<string, IPivotTableLabelFieldJSON>Represents the label fields in the pivot table.types/json-types.ts:33
filterFieldsstring[]Represents the fields id used for filtering in the pivot table.types/json-types.ts:48
hiddenFieldsstring[]Represents the fields id that are hidden in the pivot table.types/json-types.ts:63
layoutPivotLayoutTypeEnumRepresents the layout of the pivot table.types/json-types.ts:78
measureRecord<string, IPivotTableValueFieldJSON>Represents the value fields in the pivot table.types/json-types.ts:38
optionsIPivotTableOptions-types/json-types.ts:85
rowFieldsstring[]Represents the fields id used for grouping rows in the pivot table.types/json-types.ts:53
valueFieldsstring[]Represents the fields id used for grouping value in the pivot table.types/json-types.ts:43
valueIndexnumberRepresents the special ΣValue fields order index in the dimension fields.types/json-types.ts:68
valuePositionPivotTableValuePositionEnumRepresents the special ΣValue fields position in row or column area.types/json-types.ts:73