com.aspose.slides

Interfaces

Classes

Exceptions

com.aspose.slides

Class ChartDataCell

  • java.lang.Object
    • com.aspose.slides.ChartDataCell
  • All Implemented Interfaces:
    IChartDataCell


    public class ChartDataCell
    extends java.lang.Object
    implements IChartDataCell

    Represents cell for chart data.

    • Method Summary

      All Methods Instance Methods Concrete Methods 
      Modifier and Type Method and Description
      IChartDataWorksheet getChartDataWorksheet()
      Gets the worksheet.
      int getColumn()
      Returns the index of the column of worksheet in which the cell is located.
      java.lang.String getCustomNumberFormat()
      Gets or sets the custom display format of numbers and dates.
      java.lang.String getFormula()
      Gets or sets the formula in A1-style.
      byte getPresetNumberFormat()
      Gets or sets the built-in display format of numbers and dates.
      java.lang.String getR1C1Formula()
      Gets or sets the formula in R1C1-style.
      int getRow()
      Returns the index of the row of worksheet in which the cell is located.
      java.lang.Object getValue()
      Gets or sets the value.
      boolean isHidden()
      Determines whether the cell is hidden.
      void setCustomNumberFormat(java.lang.String value)
      Gets or sets the custom display format of numbers and dates.
      void setFormula(java.lang.String value)
      Gets or sets the formula in A1-style.
      void setPresetNumberFormat(byte value)
      Gets or sets the built-in display format of numbers and dates.
      void setR1C1Formula(java.lang.String value)
      Gets or sets the formula in R1C1-style.
      void setValue(java.lang.Object value)
      Gets or sets the value.
      • Methods inherited from class java.lang.Object

        equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
    • 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
      • 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