Methods

getCustomCalculatedFormula(isR1C1, isLocal) → String

Gets the formula of this list column.

Parameters

Name Type Optional 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 The formula of this list column.

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.

setCustomCalculatedFormula(formula, isR1C1, isLocal)

Sets the formula for this list column.

Parameters

Name Type Optional 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.

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.