aspose.cells

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.