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. |