com.aspose.slides

Method Detail

• getRow

  public final int getRow()

  Returns the index of the row of worksheet in which the cell is located. Read-only int.

  Specified by:

  getRow in interface IChartDataCell

• getColumn

  public final int getColumn()

  Returns the index of the column of worksheet in which the cell is located. Read-only int.

  Specified by:

  getColumn in interface IChartDataCell

• getValue

  public final java.lang.Object getValue()

  Gets or sets the value. Read/write Object.

  Specified by:

  getValue in interface IChartDataCell

• setValue

  public final void setValue(java.lang.Object value)

  Gets or sets the value. Read/write Object.

  Specified by:

  setValue in interface IChartDataCell

• getFormula

  public final java.lang.String getFormula()

  Gets or sets the formula in A1-style.

  ---

   
   IChartDataCell cell = workbook.getCell(0, "B2");
   cell.setFormula("1 + SUM(F2:H5)");
   
   

  Specified by:

  getFormula in interface IChartDataCell

• setFormula

  public final void setFormula(java.lang.String value)

  Gets or sets the formula in A1-style.

  ---

   
   IChartDataCell cell = workbook.getCell(0, "B2");
   cell.setFormula("1 + SUM(F2:H5)");
   
   

  Specified by:

  setFormula in interface IChartDataCell

• getR1C1Formula

  public final java.lang.String getR1C1Formula()

  Gets or sets the formula in R1C1-style.

  ---

   
   IChartDataCell cell = workbook.getCell(0, "C2");
   cell.setR1C1Formula("MAX(R2C6:R5C8) / 3");
   
   

  Specified by:

  getR1C1Formula in interface IChartDataCell

• setR1C1Formula

  public final void setR1C1Formula(java.lang.String value)

  Gets or sets the formula in R1C1-style.

  ---

   
   IChartDataCell cell = workbook.getCell(0, "C2");
   cell.setR1C1Formula("MAX(R2C6:R5C8) / 3");
   
   

  Specified by:

  setR1C1Formula in interface IChartDataCell

• getChartDataWorksheet

  public final IChartDataWorksheet getChartDataWorksheet()

  Gets the worksheet. Read-only IChartDataWorksheet.

  Specified by:

  getChartDataWorksheet in interface IChartDataCell

• isHidden

  public final boolean isHidden()

  Determines whether the cell is hidden. Read-only boolean.

  Specified by:

  isHidden in interface IChartDataCell

• getCustomNumberFormat

  public final java.lang.String getCustomNumberFormat()

  Gets or sets the custom display format of numbers and dates. If value is empty will be used PresetNumberFormat value. Read/write String.

  Specified by:

  getCustomNumberFormat in interface IChartDataCell

  Throws:

  com.aspose.ms.System.ArgumentNullException - Thrown if value is null.

• setCustomNumberFormat

  public final void setCustomNumberFormat(java.lang.String value)

  Gets or sets the custom display format of numbers and dates. If value is empty will be used PresetNumberFormat value. Read/write String.

  Specified by:

  setCustomNumberFormat in interface IChartDataCell

  Throws:

  com.aspose.ms.System.ArgumentNullException - Thrown if value is null.

• getPresetNumberFormat

  public final byte getPresetNumberFormat()

  Gets or sets the built-in display format of numbers and dates. Preset number must be in [0..22] or [37..49]". Read/write byte.

  ---

    
   0      General
   1      0
   2      0.00
   3      #,##0
   4      #,##0.00
   5      $#,##0;$-#,##0
   6      $#,##0;[Red]$-#,##0
   7      $#,##0.00;$-#,##0.00
   8      $#,##0.00;[Red]$-#,##0.00
   9      0%
   10     0.00%
   11     0.00E+00
   12     # ?/?
   13     # /
   14     m/d/yy
   15     d-mmm-yy
   16     d-mmm
   17     mmm-yy
   18     h:mm AM/PM
   19     h:mm:ss AM/PM
   20     h:mm
   21     h:mm:ss
   22     m/d/yy h:mm
   37     #,##0;-#,##0
   38     #,##0;[Red]-#,##0
   39     #,##0.00;-#,##0.00
   40     #,##0.00;[Red]-#,##0.00
   41     _ * #,##0_ ;_ * "_ ;_ @_
   42     _ $* #,##0_ ;_ $* "_ ;_ @_
   43     _ * #,##0.00_ ;_ * "??_ ;_ @_
   44     _("$"* # ##0,00_);_("$"* (# ##0,00);_("$"* "-"??_);_(@_)
   45     mm:ss
   46     h :mm:ss
   47     mm:ss.0
   48     ##0.0E+00
   49     @
    
    

  Specified by:

  getPresetNumberFormat in interface IChartDataCell

• setPresetNumberFormat

  public final void setPresetNumberFormat(byte value)

  Gets or sets the built-in display format of numbers and dates. Preset number must be in [0..22] or [37..49]". Read/write byte.

  ---

    
   0      General
   1      0
   2      0.00
   3      #,##0
   4      #,##0.00
   5      $#,##0;$-#,##0
   6      $#,##0;[Red]$-#,##0
   7      $#,##0.00;$-#,##0.00
   8      $#,##0.00;[Red]$-#,##0.00
   9      0%
   10     0.00%
   11     0.00E+00
   12     # ?/?
   13     # /
   14     m/d/yy
   15     d-mmm-yy
   16     d-mmm
   17     mmm-yy
   18     h:mm AM/PM
   19     h:mm:ss AM/PM
   20     h:mm
   21     h:mm:ss
   22     m/d/yy h:mm
   37     #,##0;-#,##0
   38     #,##0;[Red]-#,##0
   39     #,##0.00;-#,##0.00
   40     #,##0.00;[Red]-#,##0.00
   41     _ * #,##0_ ;_ * "_ ;_ @_
   42     _ $* #,##0_ ;_ $* "_ ;_ @_
   43     _ * #,##0.00_ ;_ * "??_ ;_ @_
   44     _("$"* # ##0,00_);_("$"* (# ##0,00);_("$"* "-"??_);_(@_)
   45     mm:ss
   46     h :mm:ss
   47     mm:ss.0
   48     ##0.0E+00
   49     @
    
    

  Specified by:

  setPresetNumberFormat in interface IChartDataCell

• calculate

  public final void calculate(boolean updateValues)

  If the cell contains a formula, the value will be updated base on that formula.

  Specified by:

  calculate in interface IChartDataCell

  Parameters:

  updateValues - If false, no actual calculation will be performed. Use true for possible exceptions check.