aspose.cells

Class ListColumn

Represents a column in a Table.

Property Getters/Setters Summary
functiongetFormula()
function
setFormula(value)
           Gets and sets the formula of the list column.
functiongetName()
function
setName(value)
           Gets and sets the name of the column.
functiongetRange()
Gets the range of this list column.
functiongetTotalsCalculation()
function
           Gets and sets the type of calculation in the Totals row of the list column. The value of the property is TotalsCalculation integer constant.
functiongetTotalsRowLabel()
function
           Gets and sets the display labels of total row.
 
Method Summary
functiongetCustomCalculatedFormula(isR1C1, isLocal)
Gets the formula of this list column.
functiongetCustomTotalsRowFormula(isR1C1, isLocal)
Gets the formula of totals row of this list column.
functiongetDataStyle()
Gets the style of the data in this column of the table.
functionsetCustomCalculatedFormula(formula, isR1C1, isLocal)
Sets the formula for this list column.
functionsetCustomTotalsRowFormula(formula, isR1C1, isLocal)
Gets the formula of totals row of this list column.
functionsetDataStyle(style)
Sets the style of the data in this column of the table.
 

    • 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.
      • getTotalsRowLabel/setTotalsRowLabel : String 

        function getTotalsRowLabel() / function setTotalsRowLabel(value)
        
        Gets and sets the display labels of total row.
    • Method Detail

      • getCustomTotalsRowFormula

        function getCustomTotalsRowFormula(isR1C1, isLocal)
        Gets the formula of totals row 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.
      • setCustomTotalsRowFormula

        function setCustomTotalsRowFormula(formula, isR1C1, isLocal)
        Gets the formula of totals row of 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.
      • 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.
      • getDataStyle

        function getDataStyle()
        Gets the style of the data in this column of the table.
      • setDataStyle

        function setDataStyle(style)
        Sets the style of the data in this column of the table.