public class ChartDataCell extends java.lang.Object implements IChartDataCell
Represents cell for chart data.
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.
|
public final int getRow()
Returns the index of the row of worksheet in which the cell is located.
Read-only int
.
getRow
in interface IChartDataCell
public final int getColumn()
Returns the index of the column of worksheet in which the cell is located.
Read-only int
.
getColumn
in interface IChartDataCell
public final java.lang.Object getValue()
Gets or sets the value.
Read/write Object
.
getValue
in interface IChartDataCell
public final void setValue(java.lang.Object value)
Gets or sets the value.
Read/write Object
.
setValue
in interface IChartDataCell
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)");
getFormula
in interface IChartDataCell
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)");
setFormula
in interface IChartDataCell
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");
getR1C1Formula
in interface IChartDataCell
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");
setR1C1Formula
in interface IChartDataCell
public final IChartDataWorksheet getChartDataWorksheet()
Gets the worksheet.
Read-only IChartDataWorksheet
.
getChartDataWorksheet
in interface IChartDataCell
public final boolean isHidden()
Determines whether the cell is hidden.
Read-only boolean
.
isHidden
in interface IChartDataCell
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
.
getCustomNumberFormat
in interface IChartDataCell
com.aspose.ms.System.ArgumentNullException
- Thrown if value is null
.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
.
setCustomNumberFormat
in interface IChartDataCell
com.aspose.ms.System.ArgumentNullException
- Thrown if value is null
.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 @
getPresetNumberFormat
in interface IChartDataCell
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 @
setPresetNumberFormat
in interface IChartDataCell
Copyright © 2004-2020 Aspose Pty Ltd. All Rights Reserved.