Namespace OpenLanguage.SpreadsheetML.Formula.Ast
Classes
- BangReferenceNode
Represents a reference prefixed with a bang, e.g., "!MyName" or "!A1".
- ExpressionNode
Represents a node that can be evaluated to a value. This base class now includes properties to retain all surrounding whitespace for lossless parsing.
- Node
The base class for all nodes in the Abstract Syntax Tree (AST).
- ParenthesizedExpressionNode
Represents an expression that was explicitly enclosed in parentheses in the original formula.
- SheetNode
Represents a single sheet name, which may be quoted or unquoted, and may have a workbook index.
- SheetRangeNode
Represents a range of sheets, e.g., "Sheet1:Sheet3".
- SheetReferenceNode
Represents a reference to a single sheet, e.g., "Sheet1!A1".
- WorkbookReferenceNode
Represents a workbook index, e.g., "[1]" or "[MyWorkbook.xlsx]".
- XlbgnmFunctionPrefixNode
Represents the "_xlbgnm." prefix for Big Grid Name compatibility. string? representation: "_xlbgnm." Used when old defined names conflict with new cell references in extended column ranges.
- XlfnFunctionPrefixNode
Represents the "_xlfn." prefix for Excel Function Name resolution. string? representation: "_xlfn." Used for new Excel functions that may not be recognized by older Excel versions. This prefix indicates that the function name should be resolved at runtime by the Excel engine.
- XllFunctionPrefixNode
Represents the "_xll." prefix for Excel Library functions. string? representation: "_xll." Used for functions provided by Excel add-in libraries (XLL files). These functions extend Excel's capabilities through custom libraries and external add-ins.
- XlnmFunctionPrefixNode
Represents the "_xlnm." prefix for Excel built-in defined names. string? representation: "_xlnm." Used for internal named ranges and built-in names like Print_Area.
- XlopPrefixNode
Represents the "_xlop." prefix for LAMBDA optional parameters. string? representation: "_xlop." Used internally by Excel to identify optional arguments in LAMBDA. This prefix node derives directly from PrefixNode (not FunctionPrefixNode).
- XlpmFunctionPrefixNode
Represents the "_xlpm." prefix for LAMBDA/LET parameter names. string? representation: "_xlpm." Used internally in Excel for lambda and let function parameters.
- XlwsFunctionPrefixNode
Represents the "_xlws." prefix for Excel Worksheet functions. string? representation: "_xlws." Used for worksheet-specific functions and operations in Excel. These functions provide worksheet manipulation, cell operations, and sheet-level functionality.