IChartDataCell class

IChartDataCell class

Represents cell for chart data.

The IChartDataCell type exposes the following members:

Properties

PropertyDescription
rowReturns the index of the row of worksheet in which the cell is located.
Read-only int.
columnReturns the index of the column of worksheet in which the cell is located.
Read-only int.
valueGets or sets the value of a cell.
Read/write any.
formulaGets or sets the formula in A1-style.
r1c1_formulaGets or sets the formula in R1C1-style.
chart_data_worksheetGets the worksheet.
Read-only IChartDataWorksheet.
is_hiddenDetermines whether the cell is hidden.
Read-only bool.
custom_number_formatGets or sets the custom display format of numbers and dates.
If value is empty will be used PresetNumberFormat value.
Read/write str.
preset_number_formatGets or sets the built-in display format of numbers and dates. Preset number must be in [0..22] or [37..49].
Read/write int.

Methods

MethodDescription
calculateIf the cell contains a formula, the value will be updated base on that formula.

See Also