Class
ExcelFormulaInfo
OfficeIMO.Excel
Formula metadata discovered during workbook analysis.
Inheritance
- object
- ExcelFormulaInfo
Usage
Explore 1 API references to this type
This type appears in these public API surfaces even when no hand-authored example is attached directly to the page.
Returned or exposed by 1
- Property ExcelFormulaAnalysisReport.Formulas
Inherited Methods
Properties
public string SheetName { get; } #Gets the containing worksheet name.
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 bool HasExternalReference { get; } #Gets whether the formula text contains an opening bracket, which can indicate an external workbook or a structured table reference.
public bool IsVolatile { get; } #Gets whether the formula uses a known volatile function.