ListColumn

aspose.cells
Class ListColumn

Represents a column in a list.

Property Getters/Setters Summary
`function`	`getFormula()`
`function`	`setFormula(value)`
	Gets and sets the formula of the list column.
`function`	`getName()`
`function`	`setName(value)`
	Gets and sets the name of the column.
`function`	`getRange()`
	Gets the range of this list column.
`function`	`getTotalsCalculation()`
`function`	`setTotalsCalculation(value)`
	Gets and sets the type of calculation in the Totals row of the list column. The value of the property is TotalsCalculation integer constant.

Method Summary
`function`	`getCustomCalculatedFormula(isR1C1, isLocal)`
`function`	Gets the formula of this list column.
`function`	`setCustomCalculatedFormula(formula, isR1C1, isLocal)`
`function`	Sets the formula for this list column.

Property Getters/Setters Detail

getName/setName : String
function getName() / function setName(value)

Gets and sets the name of the column.

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

getTotalsCalculation/setTotalsCalculation : Number
function getTotalsCalculation() / function setTotalsCalculation(value)

Gets and sets the type of calculation in the Totals row of the list column. The value of the property is TotalsCalculation integer constant.

getRange : Range
function getRange()

Gets the range of this list column.

getFormula/setFormula : String
function getFormula() / function setFormula(value)

Gets and sets the formula of the list column.

Method Detail

getCustomCalculatedFormula
function getCustomCalculatedFormula(isR1C1, isLocal)

Gets the formula of this list column.

Parameters:: isR1C1: boolean - Whether the formula needs to be formatted as R1C1.; isLocal: boolean - Whether the formula needs to be formatted by locale.

setCustomCalculatedFormula
function setCustomCalculatedFormula(formula, isR1C1, isLocal)

Sets the formula for this list column.

Parameters:: 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.

See Also:
Aspose.Cells Documentation - the home page for the Aspose.Cellss Product Documentation.
Aspose.Cells Support Forum - our preferred method of support.