API Reference

Class

ExcelFormulaDependencyNode

Namespace OfficeIMO.Excel
Assembly OfficeIMO.Excel
Modifiers sealed

Formula cell node in a workbook-level dependency graph.

Inheritance

  • Object
  • ExcelFormulaDependencyNode

Usage

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

Properties

public String Reference { get; } #

Qualified formula cell reference, such as Sheet1!A1.

public String SheetName { get; } #

Worksheet name.

public String CellReference { get; } #

A1 cell reference.

public IReadOnlyList<String> Dependencies { get; } #

Direct A1/range dependencies detected for this formula.

public IReadOnlyList<String> Dependents { get; } #

Formula cells that directly depend on this formula cell.

public IReadOnlyList<String> DependencyIssues { get; } #

Dependency diagnostics associated with this formula cell.

public Boolean HasDependencyIssues { get; } #

True when dependency diagnostics found one or more issues.