IChartDataCell

IChartDataCell class

Represents cell for chart data.

The IChartDataCell type exposes the following members:

Name	Description
row	Returns the index of the row of worksheet in which the cell is located. Read-only
column	Returns the index of the column of worksheet in which the cell is located. Read-only
value	Gets or sets the value of a cell. Read/write object.
formula	Gets or sets the formula in A1-style.
r1c1_formula	Gets or sets the formula in R1C1-style.
chart_data_worksheet	Gets the worksheet. Read-only IChartDataWorksheet.
is_hidden	Determines whether the cell is hidden. Read-only bool.
custom_number_format	Gets or sets the custom display format of numbers and dates. If value is empty will be used PresetNumberFormat value. Read/write string.
preset_number_format	Gets or sets the built-in display format of numbers and dates. Preset number must be in [0..22] or [37..49]. Read/write int.

Name	Description
calculate(update_values)	If the cell contains a formula, the value will be updated base on that formula.