ListColumn

ListColumn class

Represents a column in a Table.

class ListColumn;

Properties

PropertyTypeDescription
namestringGets and sets the name of the column.
totalsCalculationTotalsCalculationGets and sets the type of calculation in the Totals row of the list column.
rangeRangeReadonly. Gets the range of this list column.
isArrayFormulabooleanReadonly. Indicates whether the fomula is array formula.
formulastringGets and sets the formula of the list column.
totalsRowLabelstringGets and sets the display labels of total row.

Methods

MethodDescription
getCustomTotalsRowFormula(boolean, boolean)Gets the formula of totals row of this list column.
setCustomTotalsRowFormula(string, boolean, boolean)Gets the formula of totals row of this list column.
getCustomCalculatedFormula(boolean, boolean)Gets the formula of this list column.
setCustomCalculatedFormula(string, boolean, boolean)Sets the formula for this list column.
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.

name

Gets and sets the name of the column.

name : string;

Remarks

If sets the name of the column, the according cell’ value will be changed too.

totalsCalculation

Gets and sets the type of calculation in the Totals row of the list column.

totalsCalculation : TotalsCalculation;

range

Readonly. Gets the range of this list column.

range : Range;

isArrayFormula

Readonly. Indicates whether the fomula is array formula.

isArrayFormula : boolean;

formula

Gets and sets the formula of the list column.

formula : string;

totalsRowLabel

Gets and sets the display labels of total row.

totalsRowLabel : string;

getCustomTotalsRowFormula(boolean, boolean)

Gets the formula of totals row of this list column.

getCustomTotalsRowFormula(isR1C1: boolean, isLocal: boolean) : string;

Parameters:

ParameterTypeDescription
isR1C1booleanWhether the formula needs to be formatted as R1C1.
isLocalbooleanWhether the formula needs to be formatted by locale.

Returns

The formula of this list column.

setCustomTotalsRowFormula(string, boolean, boolean)

Gets the formula of totals row of this list column.

setCustomTotalsRowFormula(formula: string, isR1C1: boolean, isLocal: boolean) : void;

Parameters:

ParameterTypeDescription
formulastringthe formula for this list column.
isR1C1booleanWhether the formula needs to be formatted as R1C1.
isLocalbooleanWhether the formula needs to be formatted by locale.

getCustomCalculatedFormula(boolean, boolean)

Gets the formula of this list column.

getCustomCalculatedFormula(isR1C1: boolean, isLocal: boolean) : string;

Parameters:

ParameterTypeDescription
isR1C1booleanWhether the formula needs to be formatted as R1C1.
isLocalbooleanWhether the formula needs to be formatted by locale.

Returns

The formula of this list column.

setCustomCalculatedFormula(string, boolean, boolean)

Sets the formula for this list column.

setCustomCalculatedFormula(formula: string, isR1C1: boolean, isLocal: boolean) : void;

Parameters:

ParameterTypeDescription
formulastringthe formula for this list column.
isR1C1booleanWhether the formula needs to be formatted as R1C1.
isLocalbooleanWhether the formula needs to be formatted by locale.

getDataStyle()

Gets the style of the data in this column of the table.

getDataStyle() : Style;

Returns

Style

setDataStyle(Style)

Sets the style of the data in this column of the table.

setDataStyle(style: Style) : void;

Parameters:

ParameterTypeDescription
styleStyle