com.aspose.slides

Interfaces

Classes

Exceptions

com.aspose.slides

Interface IChartDataCell

  • All Known Implementing Classes:
    ChartDataCell


    public interface IChartDataCell

    Represents cell for chart data.

    • Method Summary

      All Methods Instance Methods Abstract 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.
    • Method Detail

      • getRow

        int getRow()

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

      • getColumn

        int getColumn()

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

      • getValue

        java.lang.Object getValue()

        Gets or sets the value. Read/write Object.

      • setValue

        void setValue(java.lang.Object value)

        Gets or sets the value. Read/write Object.

      • getFormula

        java.lang.String getFormula()

        Gets or sets the formula in A1-style.


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

        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)");
         
      • getR1C1Formula

        java.lang.String getR1C1Formula()

        Gets or sets the formula in R1C1-style.


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

        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");
         
      • isHidden

        boolean isHidden()

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

      • getCustomNumberFormat

        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.

        Throws:
        com.aspose.ms.System.ArgumentNullException - Thrown if value is null.
      • setCustomNumberFormat

        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.

        Throws:
        com.aspose.ms.System.ArgumentNullException - Thrown if value is null.
      • getPresetNumberFormat

        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_ ;_ $* "??_ ;_ @_
         45     mm:ss
         46     h :mm:ss
         47     mm:ss.0
         48     ##0.0E+00
         49     @
          
      • setPresetNumberFormat

        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_ ;_ $* "??_ ;_ @_
         45     mm:ss
         46     h :mm:ss
         47     mm:ss.0
         48     ##0.0E+00
         49     @