ChartDataCell
ChartDataCell class
Represents cell for chart data.
calculate
Name | Description |
---|
calculate(boolean) | If the cell contains a formula, the value will be updated base on that formula. |
Parameters:
Name | Type | Description |
---|
updateValues | boolean | If false, no actual calculation will be performed. Use true for possible exceptions check. |
getChartDataWorksheet
Name | Description |
---|
getChartDataWorksheet() | Gets the worksheet. Read-only IChartDataWorksheet. |
Returns:
ChartDataWorksheet
getColumn
Name | Description |
---|
getColumn() | Returns the index of the column of worksheet in which the cell is located. Read-only int. |
Returns:
int
Name | Description |
---|
getCustomNumberFormat() | Gets or sets the custom display format of numbers and dates. If value is empty will be used PresetNumberFormat value. Read/write String. |
Returns:
String
Error
Error | Condition |
---|
ArgumentNullException | Thrown if value is null. |
Name | Description |
---|
getFormula() | Gets or sets the formula in A1-style. |
Returns:
String
Name | Description |
---|
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. |
Returns:
byte
Name | Description |
---|
getR1C1Formula() | Gets or sets the formula in R1C1-style. |
Returns:
String
getRow
Name | Description |
---|
getRow() | Returns the index of the row of worksheet in which the cell is located. Read-only int. |
Returns:
int
getValue
Name | Description |
---|
getValue() | Gets or sets the value of a cell. Read/write Object. |
Returns:
Object
isHidden
Name | Description |
---|
isHidden() | Determines whether the cell is hidden. Read-only boolean. |
Returns:
boolean
Name | Description |
---|
setCustomNumberFormat(String) | Gets or sets the custom display format of numbers and dates. If value is empty will be used PresetNumberFormat value. Read/write String. |
Error
Error | Condition |
---|
ArgumentNullException | Thrown if value is null. |
Name | Description |
---|
setFormula(String) | Gets or sets the formula in A1-style. |
Name | Description |
---|
setPresetNumberFormat(byte) | 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. |
Name | Description |
---|
setR1C1Formula(String) | Gets or sets the formula in R1C1-style. |
setValue
Name | Description |
---|
setValue(Object) | Gets or sets the value of a cell. Read/write Object. |