asposecells.api

asposecells.api

Class ListColumn

Represents a column in a Table.

Property Getters/Setters Summary
methodgetFormula()
method
setFormula(value)
           Gets and sets the formula of the list column.
methodgetName()
method
setName(value)
           Gets and sets the name of the column.
methodgetRange()
Gets the range of this list column.
methodgetTotalsCalculation()
method
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.
methodgetTotalsRowLabel()
method
setTotalsRowLabel(value)
           Gets and sets the display labels of total row.
 
Method Summary
methodgetCustomCalculatedFormula(isR1C1, isLocal)
Gets the formula of this list column.
methodgetCustomTotalsRowFormula(isR1C1, isLocal)
Gets the formula of totals row of this list column.
methodgetDataStyle()
Gets the style of the data in this column of the table.
methodsetCustomCalculatedFormula(formula, isR1C1, isLocal)
Sets the formula for this list column.
methodsetCustomTotalsRowFormula(formula, isR1C1, isLocal)
Gets the formula of totals row of this list column.
methodsetDataStyle(style)
Sets the style of the data in this column of the table.
 

    • Property Getters/Setters Detail

      • getName/setName : String 

        String getName() / 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 : int 

        int getTotalsCalculation() / 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 

        Range getRange()
        Gets the range of this list column.

      • getFormula/setFormula : String 

        String getFormula() / setFormula(value)
        Gets and sets the formula of the list column.

      • getTotalsRowLabel/setTotalsRowLabel : String 

        String getTotalsRowLabel() / setTotalsRowLabel(value)
        Gets and sets the display labels of total row.

    • Method Detail

      • getCustomTotalsRowFormula

        String 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

         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

        String 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

         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

        Style getDataStyle()
        Gets the style of the data in this column of the table.

      • setDataStyle

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