Class XlsxFormulaCell

Namespace

DocToolkit

Assembly

DocToolkit.Xlsx.dll

One formula cell, as found by InspectFormulas(byte[]).

public sealed class XlsxFormulaCell

Inheritance

object

XlsxFormulaCell

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.ReferenceEquals(object, object)

object.ToString()

Properties

CellReference

The cell's A1-style reference, such as C1.

public string CellReference { get; }

Property Value

string

Formula

The formula text, without a leading = — see Formula.

public string Formula { get; }

Property Value

string

IsSupported

Whether the underlying engine understands this formula. false means any value read for this cell — through this package's own readers or any other tool — is not something anything here computed; treat it as absent rather than as a number to trust.

public bool IsSupported { get; }

Property Value

bool

SheetName

The sheet the formula lives on.

public string SheetName { get; }

Property Value

string

UnsupportedReason

Why IsSupported is false. null when the formula is supported.

public string? UnsupportedReason { get; }

Property Value

string