- 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.Spread.Pivot.PivotTableTheme
Class: PivotTableTheme
Table of contents
Constructors
Methods
- blankRowStyle
- columnSubheading1Style
- columnSubheading2Style
- columnSubheading3Style
- firstColumnStripSize
- firstColumnStripeStyle
- firstColumnStyle
- firstHeaderCellStyle
- firstRowStripSize
- firstRowStripeStyle
- grandTotalColumnStyle
- grandTotalRowStyle
- headerRowStyle
- name
- reportFilterLabelsStyle
- reportFilterValuesStyle
- rowSubheading1Style
- rowSubheading2Style
- rowSubheading3Style
- secondColumnStripSize
- secondColumnStripeStyle
- secondRowStripSize
- secondRowStripeStyle
- subtotalColumn1Style
- subtotalColumn2Style
- subtotalColumn3Style
- subtotalRow1Style
- subtotalRow2Style
- subtotalRow3Style
- wholeTableStyle
Constructors
constructor
• new PivotTableTheme()
Represents a PivotTableTheme class.
Methods
blankRowStyle
▸ blankRowStyle(value?): any
description get or set the blankRowStyle of pivot table theme
Parameters
| Name | Type |
|---|---|
value? |
PivotTableStyle |
Returns
any
If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.
columnSubheading1Style
▸ columnSubheading1Style(value?): any
description get or set the columnSubheading1Style of pivot table theme
Parameters
| Name | Type |
|---|---|
value? |
PivotTableStyle |
Returns
any
If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.
columnSubheading2Style
▸ columnSubheading2Style(value?): any
description get or set the columnSubheading2Style of pivot table theme
Parameters
| Name | Type |
|---|---|
value? |
PivotTableStyle |
Returns
any
If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.
columnSubheading3Style
▸ columnSubheading3Style(value?): any
description get or set the columnSubheading3Style of pivot table theme
Parameters
| Name | Type |
|---|---|
value? |
PivotTableStyle |
Returns
any
If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.
firstColumnStripSize
▸ firstColumnStripSize(value?): any
description get or set the firstColumnStripSize of pivot table theme
Parameters
| Name | Type |
|---|---|
value? |
number |
Returns
any
If no value is set, returns the size of the size of the first alternating column; otherwise, returns the pivot table theme.
firstColumnStripeStyle
▸ firstColumnStripeStyle(value?): any
description get or set the firstColumnStripeStyle of pivot table theme
Parameters
| Name | Type |
|---|---|
value? |
PivotTableStyle |
Returns
any
If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.
firstColumnStyle
▸ firstColumnStyle(value?): any
description get or set the firstColumnStyle of pivot table theme
Parameters
| Name | Type |
|---|---|
value? |
PivotTableStyle |
Returns
any
If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.
firstHeaderCellStyle
▸ firstHeaderCellStyle(value?): any
description get or set the firstHeaderCellStyle of pivot table theme
Parameters
| Name | Type |
|---|---|
value? |
PivotTableStyle |
Returns
any
If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.
firstRowStripSize
▸ firstRowStripSize(value?): any
description get or set the firstRowStripSize of pivot table theme
Parameters
| Name | Type |
|---|---|
value? |
number |
Returns
any
If no value is set, returns the size of the first alternating row; otherwise, returns the pivot table theme.
firstRowStripeStyle
▸ firstRowStripeStyle(value?): any
description get or set the firstRowStripeStyle of pivot table theme
Parameters
| Name | Type |
|---|---|
value? |
PivotTableStyle |
Returns
any
If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.
grandTotalColumnStyle
▸ grandTotalColumnStyle(value?): any
description get or set the grandTotalColumnStyle of pivot table theme
Parameters
| Name | Type |
|---|---|
value? |
PivotTableStyle |
Returns
any
If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.
grandTotalRowStyle
▸ grandTotalRowStyle(value?): any
description get or set the grandTotalRowStyle of pivot table theme
Parameters
| Name | Type |
|---|---|
value? |
PivotTableStyle |
Returns
any
If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.
headerRowStyle
▸ headerRowStyle(value?): any
description get or set the headerRowStyle of pivot table theme
Parameters
| Name | Type |
|---|---|
value? |
PivotTableStyle |
Returns
any
If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.
name
▸ name(value?): any
description get or set the name of pivot table theme
Parameters
| Name | Type |
|---|---|
value? |
string |
Returns
any
If no value is set, returns the name of the style; otherwise, returns the table theme.
reportFilterLabelsStyle
▸ reportFilterLabelsStyle(value?): any
description get or set the reportFilterLabelsStyle of pivot table theme
Parameters
| Name | Type |
|---|---|
value? |
PivotTableStyle |
Returns
any
If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.
reportFilterValuesStyle
▸ reportFilterValuesStyle(value?): any
description get or set the reportFilterValuesStyle of pivot table theme
Parameters
| Name | Type |
|---|---|
value? |
PivotTableStyle |
Returns
any
If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.
rowSubheading1Style
▸ rowSubheading1Style(value?): any
description get or set the rowSubheading1Style of pivot table theme
Parameters
| Name | Type |
|---|---|
value? |
PivotTableStyle |
Returns
any
If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.
rowSubheading2Style
▸ rowSubheading2Style(value?): any
description get or set the rowSubheading2Style of pivot table theme
Parameters
| Name | Type |
|---|---|
value? |
PivotTableStyle |
Returns
any
If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.
rowSubheading3Style
▸ rowSubheading3Style(value?): any
description get or set the rowSubheading3Style of pivot table theme
Parameters
| Name | Type |
|---|---|
value? |
PivotTableStyle |
Returns
any
If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.
secondColumnStripSize
▸ secondColumnStripSize(value?): any
description get or set the secondColumnStripSize of pivot table theme
Parameters
| Name | Type |
|---|---|
value? |
number |
Returns
any
If no value is set, returns the size of the second alternating column; otherwise, returns the pivot table theme.
secondColumnStripeStyle
▸ secondColumnStripeStyle(value?): any
description get or set the secondColumnStripeStyle of pivot table theme
Parameters
| Name | Type |
|---|---|
value? |
PivotTableStyle |
Returns
any
If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.
secondRowStripSize
▸ secondRowStripSize(value?): any
description get or set the secondRowStripSize of pivot table theme
Parameters
| Name | Type |
|---|---|
value? |
number |
Returns
any
If no value is set, returns the size of the second alternating row; otherwise, returns the pivot table theme.
secondRowStripeStyle
▸ secondRowStripeStyle(value?): any
description get or set the secondRowStripeStyle of pivot table theme
Parameters
| Name | Type |
|---|---|
value? |
PivotTableStyle |
Returns
any
If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.
subtotalColumn1Style
▸ subtotalColumn1Style(value?): any
description get or set the subtotalColumn1Style of pivot table theme
Parameters
| Name | Type |
|---|---|
value? |
PivotTableStyle |
Returns
any
If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.
subtotalColumn2Style
▸ subtotalColumn2Style(value?): any
description get or set the subtotalColumn2Style of pivot table theme
Parameters
| Name | Type |
|---|---|
value? |
PivotTableStyle |
Returns
any
If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.
subtotalColumn3Style
▸ subtotalColumn3Style(value?): any
description get or set the subtotalColumn3Style of pivot table theme
Parameters
| Name | Type |
|---|---|
value? |
PivotTableStyle |
Returns
any
If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.
subtotalRow1Style
▸ subtotalRow1Style(value?): any
description get or set the subtotalRow1Style of pivot table theme
Parameters
| Name | Type |
|---|---|
value? |
PivotTableStyle |
Returns
any
If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.
subtotalRow2Style
▸ subtotalRow2Style(value?): any
description get or set the subtotalRow2Style of pivot table theme
Parameters
| Name | Type |
|---|---|
value? |
PivotTableStyle |
Returns
any
If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.
subtotalRow3Style
▸ subtotalRow3Style(value?): any
description get or set the subtotalRow3Style of pivot table theme
Parameters
| Name | Type |
|---|---|
value? |
PivotTableStyle |
Returns
any
If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.
wholeTableStyle
▸ wholeTableStyle(value?): any
description get or set the wholeTableStyle of pivot table theme
Parameters
| Name | Type |
|---|---|
value? |
PivotTableStyle |
Returns
any
If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.