Interface Properties

A table style is a collection of cell styles that are applied to a table. These are applied in a specific order and merged to create a single cell style.

The order is: Whole Table

First Column Stripe
Second Column Stripe
First Row Stripe
Second Row Stripe
Last Column
First Column
Header Row
Total Row
First Header Cell
Last Header Cell
First Total Cell
Last Total Cell

A pivot table style also has the PivotElementType elements, and is applied in its own order: whole table, page field labels and values, column then row stripes, first column, header row, first header cell, subtotal columns, blank row, subtotal rows, column subheadings, row subheadings, grand total column (lastColumn), grand total row (totalRow).

interface Properties {
    blankRow?: ICellStyle.Properties<Serializable>;
    firstColumn?: ICellStyle.Properties<Serializable>;
    firstColumnStripe?: SizeBasedProperties;
    firstColumnSubheading?: ICellStyle.Properties<Serializable>;
    firstHeaderCell?: ICellStyle.Properties<Serializable>;
    firstRowStripe?: SizeBasedProperties;
    firstRowSubheading?: ICellStyle.Properties<Serializable>;
    firstSubtotalColumn?: ICellStyle.Properties<Serializable>;
    firstSubtotalRow?: ICellStyle.Properties<Serializable>;
    firstTotalCell?: ICellStyle.Properties<Serializable>;
    headerRow?: ICellStyle.Properties<Serializable>;
    lastColumn?: ICellStyle.Properties<Serializable>;
    lastHeaderCell?: ICellStyle.Properties<Serializable>;
    lastTotalCell?: ICellStyle.Properties<Serializable>;
    name: string;
    pageFieldLabels?: ICellStyle.Properties<Serializable>;
    pageFieldValues?: ICellStyle.Properties<Serializable>;
    pivot?: boolean;
    secondColumnStripe?: SizeBasedProperties;
    secondColumnSubheading?: ICellStyle.Properties<Serializable>;
    secondRowStripe?: SizeBasedProperties;
    secondRowSubheading?: ICellStyle.Properties<Serializable>;
    secondSubtotalColumn?: ICellStyle.Properties<Serializable>;
    secondSubtotalRow?: ICellStyle.Properties<Serializable>;
    table?: boolean;
    thirdColumnSubheading?: ICellStyle.Properties<Serializable>;
    thirdRowSubheading?: ICellStyle.Properties<Serializable>;
    thirdSubtotalColumn?: ICellStyle.Properties<Serializable>;
    thirdSubtotalRow?: ICellStyle.Properties<Serializable>;
    totalRow?: ICellStyle.Properties<Serializable>;
    wholeTable?: ICellStyle.Properties<Serializable>;
}

Hierarchy (View Summary)

Properties
- ITableStyle.JSON

Properties

`Optional`blankRow

blankRow?: ICellStyle.Properties<Serializable>

A pivot table's blank row after an item.

`Optional`firstColumn

firstColumn?: ICellStyle.Properties<Serializable>

For the first column.

`Optional`firstColumnStripe

firstColumnStripe?: SizeBasedProperties

Properties for the first set of alternating columns.

`Optional`firstColumnSubheading

firstColumnSubheading?: ICellStyle.Properties<Serializable>

A pivot table's column labels at the first, second and third level.

`Optional`firstHeaderCell

firstHeaderCell?: ICellStyle.Properties<Serializable>

For the first header cell. To be applied both the header and first column must be selected.

`Optional`firstRowStripe

firstRowStripe?: SizeBasedProperties

Properties for the first set of alternating rows.

`Optional`firstRowSubheading

firstRowSubheading?: ICellStyle.Properties<Serializable>

A pivot table's items with items under them, at the first, second and third level.

`Optional`firstSubtotalColumn

firstSubtotalColumn?: ICellStyle.Properties<Serializable>

A pivot table's first, second and third level of subtotal columns.

`Optional`firstSubtotalRow

firstSubtotalRow?: ICellStyle.Properties<Serializable>

A pivot table's first, second and third level of subtotal rows.

`Optional`firstTotalCell

firstTotalCell?: ICellStyle.Properties<Serializable>

For the first total cell. To be applied both the total and first column must be selected.

`Optional`headerRow

headerRow?: ICellStyle.Properties<Serializable>

For the header row.

`Optional`lastColumn

lastColumn?: ICellStyle.Properties<Serializable>

For the last column.

`Optional`lastHeaderCell

lastHeaderCell?: ICellStyle.Properties<Serializable>

For the last header cell. To be applied both the header and last column must be selected.

`Optional`lastTotalCell

lastTotalCell?: ICellStyle.Properties<Serializable>

For the last total cell. To be applied both the total and last column must be selected.

name

name: string

The name of the table style. This is the name that is shown in the UI.

`Optional`pageFieldLabels

pageFieldLabels?: ICellStyle.Properties<Serializable>

A pivot table's page field captions.

`Optional`pageFieldValues

pageFieldValues?: ICellStyle.Properties<Serializable>

A pivot table's page field items.

`Optional`pivot

pivot?: boolean

'True' if this table style should be shown as an available pivot table style.

Remarks

table and pivot can not both be true. If both false then hidden

Default Value

false

`Optional`secondColumnStripe

secondColumnStripe?: SizeBasedProperties

Properties for the second set of alternating columns.

`Optional`secondColumnSubheading

secondColumnSubheading?: ICellStyle.Properties<Serializable>

`Optional`secondRowStripe

secondRowStripe?: SizeBasedProperties

Properties for the second set of alternating rows.

`Optional`secondRowSubheading

secondRowSubheading?: ICellStyle.Properties<Serializable>

`Optional`secondSubtotalColumn

secondSubtotalColumn?: ICellStyle.Properties<Serializable>

`Optional`secondSubtotalRow

secondSubtotalRow?: ICellStyle.Properties<Serializable>

`Optional`table

table?: boolean

If this table style should be shown as an available table style.

Remarks

table and pivot can not both be true. If both false then hidden

Default Value

true

`Optional`thirdColumnSubheading

thirdColumnSubheading?: ICellStyle.Properties<Serializable>

`Optional`thirdRowSubheading

thirdRowSubheading?: ICellStyle.Properties<Serializable>

`Optional`thirdSubtotalColumn

thirdSubtotalColumn?: ICellStyle.Properties<Serializable>

`Optional`thirdSubtotalRow

thirdSubtotalRow?: ICellStyle.Properties<Serializable>

`Optional`totalRow

totalRow?: ICellStyle.Properties<Serializable>

For the total row.

`Optional`wholeTable

wholeTable?: ICellStyle.Properties<Serializable>

Properties for the whole table.