ChartDataCell

ChartDataCell class

Represents cell for chart data.

public class ChartDataCell : IChartDataCell

Properties

NameDescription
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

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

See Also