API Reference

Class

ExcelFormulaInspection

Namespace OfficeIMO.Excel
Assembly OfficeIMO.Excel
Modifiers sealed

Workbook or worksheet formula inspection result.

Inheritance

  • Object
  • ExcelFormulaInspection

Usage

This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.

Methods

public ExcelFormulaInspection EnsureAllHaveCachedResults() #
Returns: ExcelFormulaInspection

Throws when any formula lacks a cached result.

public ExcelFormulaInspection EnsureAllSupported() #
Returns: ExcelFormulaInspection

Throws when any formula is outside OfficeIMO's lightweight evaluator support.

public String ToMarkdown() #
Returns: String

Returns a compact Markdown report of formula support and cache status.

Properties

public IReadOnlyList<ExcelFormulaCellInfo> Formulas { get; } #

Formula cells discovered in workbook order.

public Int32 TotalFormulas { get; } #

Total formula count.

public Int32 SupportedFormulas { get; } #

Formula count supported by OfficeIMO's lightweight evaluator.

public Int32 UnsupportedFormulas { get; } #

Formula count that must be preserved, cached, or recalculated by Excel.

public Int32 MissingCachedResults { get; } #

Formula cells without cached results.

public Int32 DirtyFormulas { get; } #

Formula cells marked dirty for recalculation.

public Boolean AllSupported { get; } #

True when every formula can be evaluated by OfficeIMO's lightweight evaluator.

public Boolean AllHaveCachedResults { get; } #

True when every formula has a cached result.

public ExcelFormulaCapabilities Capabilities { get; } #

Describes the formula patterns supported by OfficeIMO's lightweight evaluator.