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. |
Returns: void
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
getCustomNumberFormat
| 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
Exception
| Error | Condition |
|---|---|
| ArgumentNullException | Thrown if value is null. |
getFormula
| Name | Description |
|---|---|
| getFormula () | Gets or sets the formula in A1-style. |
Returns: String
getPresetNumberFormat
| 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
getR1C1Formula
| 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
setCustomNumberFormat
| 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. |
Returns: void
Exception
| Error | Condition |
|---|---|
| ArgumentNullException | Thrown if value is null. |
setFormula
| Name | Description |
|---|---|
| setFormula (String) | Gets or sets the formula in A1-style. |
Returns: void
setPresetNumberFormat
| 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. |
Returns: void
setR1C1Formula
| Name | Description |
|---|---|
| setR1C1Formula (String) | Gets or sets the formula in R1C1-style. |
Returns: void
setValue
| Name | Description |
|---|---|
| setValue (Object) | Gets or sets the value of a cell. Read/write Object. |
Returns: void