IChartDataCell

IChartDataCell interface

Represents cell for chart data.

public interface IChartDataCell

Properties

Name Description
ChartDataWorksheet { get; } Gets the worksheet. Read-only IChartDataWorksheet.
Column { get; } Returns the index of the column of worksheet in which the cell is located. Read-only Int32.
CustomNumberFormat { get; set; } Gets or sets the custom display format of numbers and dates. If value is empty will be used PresetNumberFormat value. Read/write String.
Formula { get; set; } Gets or sets the formula in A1-style.
IsHidden { get; } Determines whether the cell is hidden. Read-only Boolean.
PresetNumberFormat { get; set; } 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.
R1C1Formula { get; set; } Gets or sets the formula in R1C1-style.
Row { get; } Returns the index of the row of worksheet in which the cell is located. Read-only Int32.
Value { get; set; } Gets or sets the value of a cell. Read/write Object.

Methods

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

See Also