Skip to main content

Search OfficeIMO

Enter a topic, API type, or PowerShell command.

Documentation Search all OfficeIMO/

API Reference

Class

ExcelFormulaInfo

Namespace OfficeIMO.Excel
Assembly OfficeIMO.Excel
Modifiers sealed

Formula metadata discovered during workbook analysis.

Inheritance

  • Object
  • ExcelFormulaInfo

Usage

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

Returned or exposed by

Properties

public String SheetName { get; } #

Gets the containing worksheet name.

public String Address { get; } #

Gets the formula cell address.

public String Formula { get; } #

Gets the formula text without a leading equals sign.

public IReadOnlyList<String> References { get; } #

Gets distinct cell and range references found in the formula.

public IReadOnlyList<String> Functions { get; } #

Gets distinct function names found in the formula.

public Boolean HasExternalReference { get; } #

Gets whether the formula text contains an opening bracket, which can indicate an external workbook or a structured table reference.

public Boolean IsVolatile { get; } #

Gets whether the formula uses a known volatile function.