API Reference
Class
SpreadsheetFormulaSyntaxTree
Lossless, nested syntax tree for Excel A1 or OpenFormula text. Parsing keeps literals and trivia while assigning separator and reference semantics from their structural context.
Inheritance
- Object
- SpreadsheetFormulaSyntaxTree
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
Methods
public static SpreadsheetFormulaSyntaxTree Parse(String text, SpreadsheetFormulaDialect dialect) #Returns:
SpreadsheetFormulaSyntaxTreeParses a formula using the requested grammar.
Parameters
- text System.String
- dialect OfficeIMO.Spreadsheet.SpreadsheetFormulaDialect
public SpreadsheetFormulaTranslationResult TranslateTo(SpreadsheetFormulaDialect targetDialect) #Returns:
SpreadsheetFormulaTranslationResultTranslates the parsed tree to another supported grammar.
Parameters
- targetDialect OfficeIMO.Spreadsheet.SpreadsheetFormulaDialect
Inherited Methods
public override Boolean Equals(Object obj) #Returns:
BooleanInherited from Object
Parameters
- obj Object
Properties
public String Text { get; } #Gets the exact authored formula.
public SpreadsheetFormulaDialect Dialect { get; } #Gets the source grammar.
public SpreadsheetFormulaSyntaxNode Root { get; } #Gets the root syntax node.
public IReadOnlyList<SpreadsheetFormulaDiagnostic> Diagnostics { get; } #Gets parse findings in source order.
public Boolean IsValid { get; } #Gets whether the authored formula is structurally valid for safe translation.