ChartDataCell

ChartDataCell class

Represents cell for chart data.

calculate

NameDescription
calculate (boolean)If the cell contains a formula, the value will be updated base on that formula.

Parameters:

NameTypeDescription
updateValuesbooleanIf false, no actual calculation will be performed. Use true for possible exceptions check.

getChartDataWorksheet

NameDescription
getChartDataWorksheet ()Gets the worksheet. Read-only IChartDataWorksheet.

Returns: ChartDataWorksheet


getColumn

NameDescription
getColumn ()Returns the index of the column of worksheet in which the cell is located. Read-only int.

Returns: int


getCustomNumberFormat

NameDescription
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

ErrorCondition
ArgumentNullExceptionThrown if value is null.

getFormula

NameDescription
getFormula ()Gets or sets the formula in A1-style.

Returns: String


getPresetNumberFormat

NameDescription
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

NameDescription
getR1C1Formula ()Gets or sets the formula in R1C1-style.

Returns: String


getRow

NameDescription
getRow ()Returns the index of the row of worksheet in which the cell is located. Read-only int.

Returns: int


getValue

NameDescription
getValue ()Gets or sets the value of a cell. Read/write Object.

Returns: Object


isHidden

NameDescription
isHidden ()Determines whether the cell is hidden. Read-only boolean.

Returns: boolean


setCustomNumberFormat

NameDescription
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

ErrorCondition
ArgumentNullExceptionThrown if value is null.

setFormula

NameDescription
setFormula (String)Gets or sets the formula in A1-style.

setPresetNumberFormat

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

setR1C1Formula

NameDescription
setR1C1Formula (String)Gets or sets the formula in R1C1-style.

setValue

NameDescription
setValue (Object)Gets or sets the value of a cell. Read/write Object.