# GC.Spread.Pivot.PivotTableTheme

## Content

# Class: PivotTableTheme

[Spread](../modules/GC.Spread).[Pivot](../modules/GC.Spread.Pivot).PivotTableTheme

## Table of contents

### Constructors

- [constructor](GC.Spread.Pivot.PivotTableTheme#constructor)

### Methods

- [blankRowStyle](GC.Spread.Pivot.PivotTableTheme#blankrowstyle)
- [columnSubheading1Style](GC.Spread.Pivot.PivotTableTheme#columnsubheading1style)
- [columnSubheading2Style](GC.Spread.Pivot.PivotTableTheme#columnsubheading2style)
- [columnSubheading3Style](GC.Spread.Pivot.PivotTableTheme#columnsubheading3style)
- [firstColumnStripSize](GC.Spread.Pivot.PivotTableTheme#firstcolumnstripsize)
- [firstColumnStripeStyle](GC.Spread.Pivot.PivotTableTheme#firstcolumnstripestyle)
- [firstColumnStyle](GC.Spread.Pivot.PivotTableTheme#firstcolumnstyle)
- [firstHeaderCellStyle](GC.Spread.Pivot.PivotTableTheme#firstheadercellstyle)
- [firstRowStripSize](GC.Spread.Pivot.PivotTableTheme#firstrowstripsize)
- [firstRowStripeStyle](GC.Spread.Pivot.PivotTableTheme#firstrowstripestyle)
- [grandTotalColumnStyle](GC.Spread.Pivot.PivotTableTheme#grandtotalcolumnstyle)
- [grandTotalRowStyle](GC.Spread.Pivot.PivotTableTheme#grandtotalrowstyle)
- [headerRowStyle](GC.Spread.Pivot.PivotTableTheme#headerrowstyle)
- [name](GC.Spread.Pivot.PivotTableTheme#name)
- [reportFilterLabelsStyle](GC.Spread.Pivot.PivotTableTheme#reportfilterlabelsstyle)
- [reportFilterValuesStyle](GC.Spread.Pivot.PivotTableTheme#reportfiltervaluesstyle)
- [rowSubheading1Style](GC.Spread.Pivot.PivotTableTheme#rowsubheading1style)
- [rowSubheading2Style](GC.Spread.Pivot.PivotTableTheme#rowsubheading2style)
- [rowSubheading3Style](GC.Spread.Pivot.PivotTableTheme#rowsubheading3style)
- [secondColumnStripSize](GC.Spread.Pivot.PivotTableTheme#secondcolumnstripsize)
- [secondColumnStripeStyle](GC.Spread.Pivot.PivotTableTheme#secondcolumnstripestyle)
- [secondRowStripSize](GC.Spread.Pivot.PivotTableTheme#secondrowstripsize)
- [secondRowStripeStyle](GC.Spread.Pivot.PivotTableTheme#secondrowstripestyle)
- [subtotalColumn1Style](GC.Spread.Pivot.PivotTableTheme#subtotalcolumn1style)
- [subtotalColumn2Style](GC.Spread.Pivot.PivotTableTheme#subtotalcolumn2style)
- [subtotalColumn3Style](GC.Spread.Pivot.PivotTableTheme#subtotalcolumn3style)
- [subtotalRow1Style](GC.Spread.Pivot.PivotTableTheme#subtotalrow1style)
- [subtotalRow2Style](GC.Spread.Pivot.PivotTableTheme#subtotalrow2style)
- [subtotalRow3Style](GC.Spread.Pivot.PivotTableTheme#subtotalrow3style)
- [wholeTableStyle](GC.Spread.Pivot.PivotTableTheme#wholetablestyle)

## Constructors

### <a id="constructor" name="constructor"></a> constructor

• **new PivotTableTheme**()

Represents a PivotTableTheme class.

## Methods

### <a id="blankrowstyle" name="blankrowstyle"></a> blankRowStyle

▸ **blankRowStyle**(`value?`): `any`

**`description`** get or set the blankRowStyle of pivot table theme

#### Parameters

| Name | Type |
| :------ | :------ |
| `value?` | [`PivotTableStyle`](GC.Spread.Pivot.PivotTableStyle) |

#### Returns

`any`

If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.

___

### <a id="columnsubheading1style" name="columnsubheading1style"></a> columnSubheading1Style

▸ **columnSubheading1Style**(`value?`): `any`

**`description`** get or set the columnSubheading1Style of pivot table theme

#### Parameters

| Name | Type |
| :------ | :------ |
| `value?` | [`PivotTableStyle`](GC.Spread.Pivot.PivotTableStyle) |

#### Returns

`any`

If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.

___

### <a id="columnsubheading2style" name="columnsubheading2style"></a> columnSubheading2Style

▸ **columnSubheading2Style**(`value?`): `any`

**`description`** get or set the columnSubheading2Style of pivot table theme

#### Parameters

| Name | Type |
| :------ | :------ |
| `value?` | [`PivotTableStyle`](GC.Spread.Pivot.PivotTableStyle) |

#### Returns

`any`

If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.

___

### <a id="columnsubheading3style" name="columnsubheading3style"></a> columnSubheading3Style

▸ **columnSubheading3Style**(`value?`): `any`

**`description`** get or set the columnSubheading3Style of pivot table theme

#### Parameters

| Name | Type |
| :------ | :------ |
| `value?` | [`PivotTableStyle`](GC.Spread.Pivot.PivotTableStyle) |

#### Returns

`any`

If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.

___

### <a id="firstcolumnstripsize" name="firstcolumnstripsize"></a> 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.

___

### <a id="firstcolumnstripestyle" name="firstcolumnstripestyle"></a> firstColumnStripeStyle

▸ **firstColumnStripeStyle**(`value?`): `any`

**`description`** get or set the firstColumnStripeStyle of pivot table theme

#### Parameters

| Name | Type |
| :------ | :------ |
| `value?` | [`PivotTableStyle`](GC.Spread.Pivot.PivotTableStyle) |

#### Returns

`any`

If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.

___

### <a id="firstcolumnstyle" name="firstcolumnstyle"></a> firstColumnStyle

▸ **firstColumnStyle**(`value?`): `any`

**`description`** get or set the firstColumnStyle of pivot table theme

#### Parameters

| Name | Type |
| :------ | :------ |
| `value?` | [`PivotTableStyle`](GC.Spread.Pivot.PivotTableStyle) |

#### Returns

`any`

If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.

___

### <a id="firstheadercellstyle" name="firstheadercellstyle"></a> firstHeaderCellStyle

▸ **firstHeaderCellStyle**(`value?`): `any`

**`description`** get or set the firstHeaderCellStyle of pivot table theme

#### Parameters

| Name | Type |
| :------ | :------ |
| `value?` | [`PivotTableStyle`](GC.Spread.Pivot.PivotTableStyle) |

#### Returns

`any`

If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.

___

### <a id="firstrowstripsize" name="firstrowstripsize"></a> 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.

___

### <a id="firstrowstripestyle" name="firstrowstripestyle"></a> firstRowStripeStyle

▸ **firstRowStripeStyle**(`value?`): `any`

**`description`** get or set the firstRowStripeStyle of pivot table theme

#### Parameters

| Name | Type |
| :------ | :------ |
| `value?` | [`PivotTableStyle`](GC.Spread.Pivot.PivotTableStyle) |

#### Returns

`any`

If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.

___

### <a id="grandtotalcolumnstyle" name="grandtotalcolumnstyle"></a> grandTotalColumnStyle

▸ **grandTotalColumnStyle**(`value?`): `any`

**`description`** get or set the grandTotalColumnStyle of pivot table theme

#### Parameters

| Name | Type |
| :------ | :------ |
| `value?` | [`PivotTableStyle`](GC.Spread.Pivot.PivotTableStyle) |

#### Returns

`any`

If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.

___

### <a id="grandtotalrowstyle" name="grandtotalrowstyle"></a> grandTotalRowStyle

▸ **grandTotalRowStyle**(`value?`): `any`

**`description`** get or set the grandTotalRowStyle of pivot table theme

#### Parameters

| Name | Type |
| :------ | :------ |
| `value?` | [`PivotTableStyle`](GC.Spread.Pivot.PivotTableStyle) |

#### Returns

`any`

If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.

___

### <a id="headerrowstyle" name="headerrowstyle"></a> headerRowStyle

▸ **headerRowStyle**(`value?`): `any`

**`description`** get or set the headerRowStyle of pivot table theme

#### Parameters

| Name | Type |
| :------ | :------ |
| `value?` | [`PivotTableStyle`](GC.Spread.Pivot.PivotTableStyle) |

#### Returns

`any`

If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.

___

### <a id="name" name="name"></a> 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.

___

### <a id="reportfilterlabelsstyle" name="reportfilterlabelsstyle"></a> reportFilterLabelsStyle

▸ **reportFilterLabelsStyle**(`value?`): `any`

**`description`** get or set the reportFilterLabelsStyle of pivot table theme

#### Parameters

| Name | Type |
| :------ | :------ |
| `value?` | [`PivotTableStyle`](GC.Spread.Pivot.PivotTableStyle) |

#### Returns

`any`

If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.

___

### <a id="reportfiltervaluesstyle" name="reportfiltervaluesstyle"></a> reportFilterValuesStyle

▸ **reportFilterValuesStyle**(`value?`): `any`

**`description`** get or set the reportFilterValuesStyle of pivot table theme

#### Parameters

| Name | Type |
| :------ | :------ |
| `value?` | [`PivotTableStyle`](GC.Spread.Pivot.PivotTableStyle) |

#### Returns

`any`

If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.

___

### <a id="rowsubheading1style" name="rowsubheading1style"></a> rowSubheading1Style

▸ **rowSubheading1Style**(`value?`): `any`

**`description`** get or set the rowSubheading1Style of pivot table theme

#### Parameters

| Name | Type |
| :------ | :------ |
| `value?` | [`PivotTableStyle`](GC.Spread.Pivot.PivotTableStyle) |

#### Returns

`any`

If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.

___

### <a id="rowsubheading2style" name="rowsubheading2style"></a> rowSubheading2Style

▸ **rowSubheading2Style**(`value?`): `any`

**`description`** get or set the rowSubheading2Style of pivot table theme

#### Parameters

| Name | Type |
| :------ | :------ |
| `value?` | [`PivotTableStyle`](GC.Spread.Pivot.PivotTableStyle) |

#### Returns

`any`

If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.

___

### <a id="rowsubheading3style" name="rowsubheading3style"></a> rowSubheading3Style

▸ **rowSubheading3Style**(`value?`): `any`

**`description`** get or set the rowSubheading3Style of pivot table theme

#### Parameters

| Name | Type |
| :------ | :------ |
| `value?` | [`PivotTableStyle`](GC.Spread.Pivot.PivotTableStyle) |

#### Returns

`any`

If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.

___

### <a id="secondcolumnstripsize" name="secondcolumnstripsize"></a> 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.

___

### <a id="secondcolumnstripestyle" name="secondcolumnstripestyle"></a> secondColumnStripeStyle

▸ **secondColumnStripeStyle**(`value?`): `any`

**`description`** get or set the secondColumnStripeStyle of pivot table theme

#### Parameters

| Name | Type |
| :------ | :------ |
| `value?` | [`PivotTableStyle`](GC.Spread.Pivot.PivotTableStyle) |

#### Returns

`any`

If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.

___

### <a id="secondrowstripsize" name="secondrowstripsize"></a> 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.

___

### <a id="secondrowstripestyle" name="secondrowstripestyle"></a> secondRowStripeStyle

▸ **secondRowStripeStyle**(`value?`): `any`

**`description`** get or set the secondRowStripeStyle of pivot table theme

#### Parameters

| Name | Type |
| :------ | :------ |
| `value?` | [`PivotTableStyle`](GC.Spread.Pivot.PivotTableStyle) |

#### Returns

`any`

If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.

___

### <a id="subtotalcolumn1style" name="subtotalcolumn1style"></a> subtotalColumn1Style

▸ **subtotalColumn1Style**(`value?`): `any`

**`description`** get or set the subtotalColumn1Style of pivot table theme

#### Parameters

| Name | Type |
| :------ | :------ |
| `value?` | [`PivotTableStyle`](GC.Spread.Pivot.PivotTableStyle) |

#### Returns

`any`

If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.

___

### <a id="subtotalcolumn2style" name="subtotalcolumn2style"></a> subtotalColumn2Style

▸ **subtotalColumn2Style**(`value?`): `any`

**`description`** get or set the subtotalColumn2Style of pivot table theme

#### Parameters

| Name | Type |
| :------ | :------ |
| `value?` | [`PivotTableStyle`](GC.Spread.Pivot.PivotTableStyle) |

#### Returns

`any`

If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.

___

### <a id="subtotalcolumn3style" name="subtotalcolumn3style"></a> subtotalColumn3Style

▸ **subtotalColumn3Style**(`value?`): `any`

**`description`** get or set the subtotalColumn3Style of pivot table theme

#### Parameters

| Name | Type |
| :------ | :------ |
| `value?` | [`PivotTableStyle`](GC.Spread.Pivot.PivotTableStyle) |

#### Returns

`any`

If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.

___

### <a id="subtotalrow1style" name="subtotalrow1style"></a> subtotalRow1Style

▸ **subtotalRow1Style**(`value?`): `any`

**`description`** get or set the subtotalRow1Style of pivot table theme

#### Parameters

| Name | Type |
| :------ | :------ |
| `value?` | [`PivotTableStyle`](GC.Spread.Pivot.PivotTableStyle) |

#### Returns

`any`

If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.

___

### <a id="subtotalrow2style" name="subtotalrow2style"></a> subtotalRow2Style

▸ **subtotalRow2Style**(`value?`): `any`

**`description`** get or set the subtotalRow2Style of pivot table theme

#### Parameters

| Name | Type |
| :------ | :------ |
| `value?` | [`PivotTableStyle`](GC.Spread.Pivot.PivotTableStyle) |

#### Returns

`any`

If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.

___

### <a id="subtotalrow3style" name="subtotalrow3style"></a> subtotalRow3Style

▸ **subtotalRow3Style**(`value?`): `any`

**`description`** get or set the subtotalRow3Style of pivot table theme

#### Parameters

| Name | Type |
| :------ | :------ |
| `value?` | [`PivotTableStyle`](GC.Spread.Pivot.PivotTableStyle) |

#### Returns

`any`

If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.

___

### <a id="wholetablestyle" name="wholetablestyle"></a> wholeTableStyle

▸ **wholeTableStyle**(`value?`): `any`

**`description`** get or set the wholeTableStyle of pivot table theme

#### Parameters

| Name | Type |
| :------ | :------ |
| `value?` | [`PivotTableStyle`](GC.Spread.Pivot.PivotTableStyle) |

#### Returns

`any`

If no value is set, returns the default style of the data area; otherwise, returns the pivot table theme.