ListColumn
ListColumn class
Represents a column in a Table.
Properties
| Name | Type | Description |
|---|---|---|
| Name | String | Gets and sets the name of the column. If sets the name of the column, the according cell’ value will be changed too. |
| TotalsCalculation | int | Gets and sets the type of calculation in the Totals row of the list column. The value of the property is TotalsCalculati |
| Range | Range | Gets the range of this list column. |
| IsArrayFormula | boolean | |
| Formula | String | Gets and sets the formula of the list column. |
| TotalsRowLabel | String | Gets and sets the display labels of total row. |
Methods
| Name | Description |
|---|---|
| getCustomTotalsRowFormula | Gets the formula of totals row of this list column. |
| setCustomTotalsRowFormula | Gets the formula of totals row of this list column. |
| getCustomCalculatedFormula | Gets the formula of this list column. |
| setCustomCalculatedFormula | Sets the formula for this list column. |
| getDataStyle | Gets the style of the data in this column of the table. |
| setDataStyle | Sets the style of the data in this column of the table. |
ListColumn.Name property
Gets and sets the name of the column. If sets the name of the column, the according cell’ value will be changed too.
Type: String
ListColumn.TotalsCalculation property
Gets and sets the type of calculation in the Totals row of the list column. The value of the property is TotalsCalculation integer constant.
Type: int
ListColumn.Range property
Gets the range of this list column.
Type: Range
ListColumn.IsArrayFormula property
Type: boolean
ListColumn.Formula property
Gets and sets the formula of the list column.
Type: String
ListColumn.TotalsRowLabel property
Gets and sets the display labels of total row.
Type: String
getCustomTotalsRowFormula(isR1C1, isLocal)
Gets the formula of totals row of this list column.
| Parameter | Type | Description |
|---|---|---|
| isR1C1 | boolean | Whether the formula needs to be formatted as R1C1. |
| isLocal | boolean | Whether the formula needs to be formatted by locale. |
Returns: The formula of this list column.
setCustomTotalsRowFormula(formula, isR1C1, isLocal)
Gets the formula of totals row of this list column.
| Parameter | Type | Description |
|---|---|---|
| formula | String | the formula for this list column. |
| isR1C1 | boolean | Whether the formula needs to be formatted as R1C1. |
| isLocal | boolean | Whether the formula needs to be formatted by locale. |
getCustomCalculatedFormula(isR1C1, isLocal)
Gets the formula of this list column.
| Parameter | Type | Description |
|---|---|---|
| isR1C1 | boolean | Whether the formula needs to be formatted as R1C1. |
| isLocal | boolean | Whether the formula needs to be formatted by locale. |
Returns: The formula of this list column.
setCustomCalculatedFormula(formula, isR1C1, isLocal)
Sets the formula for this list column.
| Parameter | Type | Description |
|---|---|---|
| formula | String | the formula for this list column. |
| isR1C1 | boolean | Whether the formula needs to be formatted as R1C1. |
| isLocal | boolean | Whether the formula needs to be formatted by locale. |
getDataStyle()
Gets the style of the data in this column of the table.
setDataStyle(style)
Sets the style of the data in this column of the table.