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.
|
byte |
getPresetNumberFormat()
Gets or sets the built-in display format of numbers and dates.
|
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 |
setPresetNumberFormat(byte value)
Gets or sets the built-in display format of numbers and dates.
|
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 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