ListColumn
ListColumn class
Represents a column in a Table.
Methods
| Name | Description |
|---|---|
| getCustomCalculatedFormula(isR1C1, isLocal) | Gets the formula of this list column. |
| getCustomTotalsRowFormula(isR1C1, isLocal) | Gets the formula of totals row of this list column. |
| getDataStyle() | Gets the style of the data in this column of the table. |
| getFormula() | Gets and sets the formula of the list column. |
| getName() | Gets and sets the name of the column. If sets the name of the column, the according cell’ value will be changed too. |
| getRange() | Gets the range of this list column. |
| getTotalsCalculation() | Gets and sets the type of calculation in the Totals row of the list column. The value of the property is TotalsCalculati |
| getTotalsRowLabel() | Gets and sets the display labels of total row. |
| isArrayFormula() | |
| setCustomCalculatedFormula(formula, isR1C1, isLocal) | Sets the formula for this list column. |
| setCustomTotalsRowFormula(formula, isR1C1, isLocal) | Gets the formula of totals row of this list column. |
| setDataStyle() | Sets the style of the data in this column of the table. |
| setFormula() | Gets and sets the formula of the list column. |
| setName() | Gets and sets the name of the column. If sets the name of the column, the according cell’ value will be changed too. |
| setTotalsCalculation() | Gets and sets the type of calculation in the Totals row of the list column. The value of the property is TotalsCalculati |
| setTotalsRowLabel() | Gets and sets the display labels of total row. |
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: String — String The formula of this list column.
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: String — String The formula of this list column.
getDataStyle()
Gets the style of the data in this column of the table.
getFormula()
Gets and sets the formula of the list column.
getName()
Gets and sets the name of the column. If sets the name of the column, the according cell’ value will be changed too.
getRange()
Gets the range of this list column.
getTotalsCalculation()
Gets and sets the type of calculation in the Totals row of the list column. The value of the property is TotalsCalculation integer constant.
getTotalsRowLabel()
Gets and sets the display labels of total row.
isArrayFormula()
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. |
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. |
setDataStyle()
Sets the style of the data in this column of the table.
setFormula()
Gets and sets the formula of the list column.
setName()
Gets and sets the name of the column. If sets the name of the column, the according cell’ value will be changed too.
setTotalsCalculation()
Gets and sets the type of calculation in the Totals row of the list column. The value of the property is TotalsCalculation integer constant.
setTotalsRowLabel()
Gets and sets the display labels of total row.