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