com.aspose.cells

com.aspose.cells

Class ListColumn

  • java.lang.Object
    • com.aspose.cells.ListColumn
public class ListColumn 
extends java.lang.Object

Represents a column in a list.

Property Getters/Setters Summary
java.lang.StringgetFormula()
void
setFormula(java.lang.Stringvalue)
           Gets and sets the formula of the list column.
java.lang.StringgetName()
void
setName(java.lang.Stringvalue)
           Gets and sets the name of the column.
RangegetRange()
Gets the range of this list column.
intgetTotalsCalculation()
void
setTotalsCalculation(intvalue)
           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
java.lang.StringgetCustomCalculatedFormula(boolean isR1C1, boolean isLocal)
Gets the formula of this list column.
voidsetCustomCalculatedFormula(java.lang.String formula, boolean isR1C1, boolean isLocal)
Sets the formula for this list column.
 

    • Property Getters/Setters Detail

      • getName/setName

        public java.lang.String getName() / public void setName(java.lang.String 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

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

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

      • getFormula/setFormula

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

    setName

    public voidsetName(java.lang.Stringvalue)
    Gets and sets the name of the column. If sets the name of the column, the according cell' value will be changed too.

    setTotalsCalculation

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

    setFormula

    public voidsetFormula(java.lang.Stringvalue)
    Gets and sets the formula of the list column.

    • Method Detail

      • getCustomCalculatedFormula

        public java.lang.String getCustomCalculatedFormula(boolean isR1C1, boolean isLocal)
        Gets the formula of this list column.
        Parameters:
        isR1C1 - Whether the formula needs to be formatted as R1C1.
        isLocal - Whether the formula needs to be formatted by locale.
        Returns:
        The formula of this list column.

      • setCustomCalculatedFormula

        public void setCustomCalculatedFormula(java.lang.String formula, boolean isR1C1, boolean isLocal)
        Sets the formula for this list column.
        Parameters:
        formula - the formula for this list column.
        isR1C1 - Whether the formula needs to be formatted as R1C1.
        isLocal - Whether the formula needs to be formatted by locale.