@univerjs-pro/engine-pivot v0.5.0-beta.1 • Docs
@univerjs-pro/engine-pivot
Enumerations
| Enumeration | Description |
|---|---|
| PivotCellStyleTypeEnum | Represents the pivot cell style type enum |
| PivotDataFieldDataTypeEnum | Enum for pivot table data field types. |
| PivotDataFieldSortOperatorEnum | Enum for pivot table data field sort types. |
| PivotDataFieldSortTypeEnum | Represents the sort types for pivot data fields. |
| PivotErrorTypeEnum | Enum for pivot table error types. |
| PivotFilterTypeEnum | Enum for pivot table data field types. |
| PivotLayoutTypeEnum | Enum for pivot table layout types. |
| PivotShowAsTypeEnum | Enum for pivot table show as types. |
| PivotSubtotalTypeEnum | Enum for pivot table subtotal types. |
| PivotTableChangeTypeEnum | - |
| PivotTableFiledAreaEnum | Enum for pivot table field types. |
| PivotTableValuePositionEnum | Enum for pivot table value field position types. in the pivot table, the value field can be placed in the column or row field. |
| PivotViewCellValueTypeEnum | - |
| ST_PivotFilterOperatorEnum | Enum for IST_PivotFilter Operator |
Classes
| Class | Description |
|---|---|
| DataField | Represents a data field in a pivot table , it match the excel pivot cache field data structure. |
| DataFieldManager | - |
| FieldsCollection | Represents the collection of fields in the pivot table. which one to one with a pivot table. |
| LabelViewItem | - |
| PageViewItem | - |
| PivotModel | PivotModel represents a config model for a pivot table. |
| PivotTable | PivotTable - represents the wrapper class pivot table. |
| PivotTableFieldBase | Represents a base class for the field in a pivot table. |
| PivotTableLabelField | Represents a label field in a pivot table. |
| PivotTableValueField | Represents a base class for the field in a pivot table. |
| PivotTuple | PivotTuple |
| PivotView | PivotView |
| PivotViewItem | - |
| SummaryManager | - |
Interfaces
Type Aliases
| Type alias | Description |
|---|---|
| IDataFieldValue | Represents the value of a data field in a pivot table data field |
| IPivotTableChangeSet | - |
| IPivotTableFilterInfo | - |
| IPivotTableSortInfo | - |
| IPivotViewValueType | - |
| ITupleItemSummary | - |
Functions
| Function | Description |
|---|---|
| cloneLabelFieldToValueField | Clone the label field to a value field. |
| cloneValueFieldToLabelField | Clone the value field to a label field. |
| createLabelField | - Create a label field from the JSON data. |
| createValueField | - Create a value field from the JSON data. |
| generateHexNumber | - Generate a random hex number text with specified length |
| getAutoDisplayName | - Get the auto display name of the value field. |
| isCustomFilter | -judge the filter info is customFilter filter |
| isDateValue | - judge the value is date like type |
| isErrorValue | judge the value is the error value, it will be a error value when the show data as or the product bigger than the max value of number in javascript |
| isManualFilter | -judge the filter info is manual filter |
| isPrefixValue | judge the value is the prefix value, once when the value is a subtotal and there are multiple value field, the value will be the prefix value |
| isValueFilter | -judge the filter info is customFilter filter |