aspose.cells
Class ListColumn

Represents a column in a list.

Property Getters/Setters Summary
functiongetFormula()
functionsetFormula(value)
           Gets and sets the formula of the list column.
functiongetName()
functionsetName(value)
           Gets and sets the name of the column.
functiongetRange()
           Gets the range of this list column.
functiongetTotalsCalculation()
functionsetTotalsCalculation(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
functiongetCustomCalculatedFormula(isR1C1, isLocal)
           Gets the formula of this list column.
functionsetCustomCalculatedFormula(formula, isR1C1, isLocal)
           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.
Returns:
The formula of this list column.

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.