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