Class XlsxFormulaInspection

Namespace

DocToolkit

Assembly

DocToolkit.Xlsx.dll

Which formulas a workbook carries, and whether each one is understood well enough to trust its value — an inventory, not a promise about what the value currently is.

public sealed class XlsxFormulaInspection

Inheritance

object

XlsxFormulaInspection

Inherited Members

object.Equals(object)

object.Equals(object, object)

object.GetHashCode()

object.GetType()

object.ReferenceEquals(object, object)

object.ToString()

Remarks

The reason this exists, stated once here rather than at every call site. A formula this package writes carries no cached result — see XlsxFormula's own remarks — and this package's own ReadCell/ReadSheet compute a value lazily, in memory, on every read. That is reliable when the reader agrees with the writer about what the formula means; it says nothing about whether it would. InspectFormulas(byte[]) asks the underlying engine directly, rather than trusting a value it produced itself.

Properties

AllSupported

Whether every formula is understood. A workbook with no formulas at all is trivially true.

public bool AllSupported { get; }

Property Value

bool

Formulas

Every formula found, in sheet then cell order.

public IReadOnlyList<XlsxFormulaCell> Formulas { get; }

Property Value

IReadOnlyList<XlsxFormulaCell>

SupportedFormulas

How many of Formulas the engine understands.

public int SupportedFormulas { get; }

Property Value

int

TotalFormulas

How many formulas the workbook carries.

public int TotalFormulas { get; }

Property Value

int

UnsupportedFormulas

How many of Formulas the engine does not understand — each carries its own reason in UnsupportedReason.

public int UnsupportedFormulas { get; }

Property Value

int