- GC
- GC.Data
- GC.Pivot
- GC.Spread.Pivot
- GC.Spread.Slicers
- GC.Spread.CalcEngine
- GC.Spread.Commands
- GC.Spread.Common
- GC.Spread.Formatter
- GC.Spread.Report
- GC.Spread.Sheets
- GC.Spread.Sheets.AutoMerge
- GC.Spread.Sheets.Barcode
- GC.Spread.Sheets.IO
- 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.DataCharts
- GC.Spread.Sheets.Commands
- GC.Spread.Sheets.Comments
- GC.Spread.Sheets.ThreadedComments
- GC.Spread.Sheets.ConditionalFormatting
- GC.Spread.Sheets.ContextMenu
- GC.Spread.Sheets.Collaboration
- GC.Spread.Sheets.DataValidation
- GC.Spread.Sheets.DataRange
- GC.Spread.Sheets.Fill
- GC.Spread.Sheets.Filter
- GC.Spread.Sheets.FloatingObjects
- GC.Spread.Sheets.FormulaTextBox
- GC.Spread.Sheets.Hyperlink
- GC.Spread.Sheets.OutlineColumn
- GC.Spread.Sheets.Outlines
- GC.Spread.Sheets.FormulaPanel
- GC.Spread.Sheets.PDF
- GC.Spread.Sheets.InputMask
- GC.Spread.Sheets.Print
- GC.Spread.Sheets.NameBox
- 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.Touch
- GC.Spread.Sheets.Designer
- GC.Spread.Sheets.GanttSheet
- GC.Spread.Sheets.AI
- Collaboration
- GC.Spread.Excel
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.
property {(string | number)[]} customSortList custom sort list for custom sort.
Type declaration
| Name | Type |
|---|---|
customSortCallback? |
ICustomSortCallBack |
customSortList? |
(string | number)[] |
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 |