- GC.Data
- GC.Pivot
- GC.Spread.CalcEngine
- GC.Spread.CalcEngine.Functions
- GC.Spread.CalcEngine.LanguagePackages
- GC.Spread.Commands
- GC.Spread.Common
- GC.Spread.Formatter
- GC.Spread.Pivot
- GC.Spread.Sheets
- GC.Spread.Sheets.IO
- GC.Spread.Sheets.AutoMerge
- GC.Spread.Sheets.Barcode
- GC.Spread.Sheets.Bindings
- GC.Spread.Sheets.CalcEngine
- GC.Spread.Sheets.Search
- GC.Spread.Sheets.CellState
- GC.Spread.Sheets.CellTypes
- GC.Spread.Sheets.Charts
- GC.Spread.Sheets.Commands
- GC.Spread.Sheets.Comments
- GC.Spread.Sheets.ConditionalFormatting
- GC.Spread.Sheets.ContextMenu
- GC.Spread.Sheets.DataValidation
- GC.Spread.Sheets.Fill
- GC.Spread.Sheets.Filter
- GC.Spread.Sheets.FloatingObjects
- GC.Spread.Sheets.FormulaTextBox
- GC.Spread.Sheets.FormulaPanel
- GC.Spread.Sheets.Hyperlink
- GC.Spread.Sheets.InputMask
- GC.Spread.Sheets.NameBox
- GC.Spread.Sheets.OutlineColumn
- GC.Spread.Sheets.Outlines
- GC.Spread.Sheets.PDF
- GC.Spread.Sheets.Print
- GC.Spread.Sheets.Shapes
- GC.Spread.Sheets.Slicers
- GC.Spread.Sheets.Sparklines
- GC.Spread.Sheets.StatusBar
- GC.Spread.Sheets.Tables
- GC.Spread.Sheets.TableSheet
- GC.Spread.Sheets.GanttSheet
- GC.Spread.Sheets.Touch
- GC.Spread.Slicers
- GC.Spread.Sheets.Designer
- GC.Spread.Excel.IO
GC.Pivot
Namespace: Pivot
GC.Pivot
Table of contents
Enumerations
- DataPosition
- DateGroupType
- PivotAdvancedDateFilterBy
- PivotCaptionFilterOperator
- PivotConditionType
- PivotDataType
- PivotDateFilterOperator
- PivotShowDataAs
- PivotShowDataAsBaseItemType
- PivotSourceFieldType
- PivotTop10FilterOperator
- PivotTop10FilterType
- PivotValueFilterOperator
- SortType
- SubtotalType
Interfaces
Type aliases
- IDataPosition
- IPivotCaptionConditionFilterInfo
- IPivotDateConditionFilterInfo
- IPivotTop10ConditionFilterInfo
- IPivotValueConditionInfo
- IPivotViewSortInfo
- IStringGroupItems
- IValueInfo
Type aliases
IDataPosition
Ƭ IDataPosition: Object
property [display]
property
property
Type declaration
| Name | Type |
|---|---|
display? |
boolean |
positionIndex |
number |
positionType |
DataPosition |
IPivotCaptionConditionFilterInfo
Ƭ IPivotCaptionConditionFilterInfo: Object
property conType
property {string[]} val
property operator
Type declaration
| Name | Type |
|---|---|
conType |
PivotConditionType |
operator |
PivotCaptionFilterOperator |
val |
string[] |
IPivotDateConditionFilterInfo
Ƭ IPivotDateConditionFilterInfo: Object
property conType
property {Date[]} val
property operator
property isWholeDay
property isDynamicEndDate
property isParallel
property by
Type declaration
| Name | Type |
|---|---|
by? |
PivotAdvancedDateFilterBy |
conType |
PivotConditionType |
isDynamicEndDate? |
boolean |
isParallel? |
boolean |
isWholeDay |
boolean |
operator |
PivotDateFilterOperator |
val |
Date[] |
IPivotTop10ConditionFilterInfo
Ƭ IPivotTop10ConditionFilterInfo: Object
property conType
property val
property type
property operator
Type declaration
| Name | Type |
|---|---|
conType |
PivotConditionType |
operator |
PivotTop10FilterOperator |
type |
PivotTop10FilterType |
val |
number |
IPivotValueConditionInfo
Ƭ IPivotValueConditionInfo: Object
property conType
property {number[]} val
property operator
Type declaration
| Name | Type |
|---|---|
conType |
PivotConditionType |
operator |
PivotValueFilterOperator |
val |
number[] |
IPivotViewSortInfo
Ƭ IPivotViewSortInfo: Object
property sortType sort field by ascending or descending or custom.
property sortValueFieldName sort field by specified value area field's value.
property {GC.Spread.Pivot.IPivotReference[]} sortByPivotReferences sort field by specified row or column. sortValueFieldName is must if use this property.
property customSortCallback sort field by custom way. should return the ordered field items array.
Type declaration
| Name | Type |
|---|---|
customSortCallback? |
ICustomSortCallBack |
sortByPivotReferences? |
IPivotReference[] |
sortType? |
SortType |
sortValueFieldName? |
string |
IStringGroupItems
Ƭ IStringGroupItems: Object
property {Object.<string, string[] | number[]>} -The group field items name and the matched items text.
Index signature
▪ [groupItemName: string]: (string | number)[]
IValueInfo
Ƭ IValueInfo: Object
property sourceName value field source name.
property subtotalType value field subtotal type.
Type declaration
| Name | Type |
|---|---|
sourceName |
string |
subtotalType |
SubtotalType |