# SpreadsheetFormulaSyntaxTree

Lossless, nested syntax tree for Excel A1 or OpenFormula text.

Class 

`OfficeIMO.Spreadsheet`

**Namespace**

`OfficeIMO.Spreadsheet`

**Assembly**

`OfficeIMO.Core`

**Source revision**

`ba882f6b0d07` with working tree changes

**Source**

[SpreadsheetFormulaSyntax.cs:181](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Core/Spreadsheet/SpreadsheetFormulaSyntax.cs#L181)

**Modifiers**

sealed

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

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

- Method [SpreadsheetFormulaSyntaxTree.Parse](/api/core/officeimo-spreadsheet-spreadsheetformulasyntaxtree/#method-parse-string-officeimo-spreadsheet-spreadsheetformuladialect)

Filter members 

Show inherited

## Methods

`public static SpreadsheetFormulaSyntaxTree Parse(string text, SpreadsheetFormulaDialect dialect)` [#](#method-parse-string-officeimo-spreadsheet-spreadsheetformuladialect)

[SpreadsheetFormulaSyntax.cs:181](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Core/Spreadsheet/SpreadsheetFormulaSyntax.cs#L181)

Parses a formula using the requested grammar.

Parameters

**text string required**

**dialect OfficeIMO.Spreadsheet.SpreadsheetFormulaDialect required**

Returns

`SpreadsheetFormulaSyntaxTree`

`public SpreadsheetFormulaTranslationResult TranslateTo(SpreadsheetFormulaDialect targetDialect)` [#](#method-translateto-officeimo-spreadsheet-spreadsheetformuladialect)

[SpreadsheetFormulaSyntax.cs:187](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Core/Spreadsheet/SpreadsheetFormulaSyntax.cs#L187)

Translates the parsed tree to another supported grammar.

Parameters

**targetDialect OfficeIMO.Spreadsheet.SpreadsheetFormulaDialect required**

Returns

`SpreadsheetFormulaTranslationResult`

## Inherited Methods

`public virtual bool Equals(object? obj)` [#](#method-equals-object)

Inherited from object

Parameters

**obj object? required**

Returns

`bool`

`public virtual int GetHashCode()` [#](#method-gethashcode)

Inherited from object

Returns

`int`

`public Type GetType()` [#](#method-gettype)

Inherited from object

Returns

`Type`

`public virtual string? ToString()` [#](#method-tostring)

Inherited from object

Returns

`string?`

## Properties

`public string Text { get; }` [#](#property-text)

[SpreadsheetFormulaSyntax.cs:165](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Core/Spreadsheet/SpreadsheetFormulaSyntax.cs#L165)

Gets the exact authored formula.

`public SpreadsheetFormulaDialect Dialect { get; }` [#](#property-dialect)

[SpreadsheetFormulaSyntax.cs:168](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Core/Spreadsheet/SpreadsheetFormulaSyntax.cs#L168)

Gets the source grammar.

`public SpreadsheetFormulaSyntaxNode Root { get; }` [#](#property-root)

[SpreadsheetFormulaSyntax.cs:171](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Core/Spreadsheet/SpreadsheetFormulaSyntax.cs#L171)

Gets the root syntax node.

`public IReadOnlyList<SpreadsheetFormulaDiagnostic> Diagnostics { get; }` [#](#property-diagnostics)

[SpreadsheetFormulaSyntax.cs:174](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Core/Spreadsheet/SpreadsheetFormulaSyntax.cs#L174)

Gets parse findings in source order.

`public bool IsValid { get; }` [#](#property-isvalid)

[SpreadsheetFormulaSyntax.cs:177](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Core/Spreadsheet/SpreadsheetFormulaSyntax.cs#L177)

Gets whether the authored formula is structurally valid for safe translation.

<!-- PowerForge markdown artifact sha256:44FC83936F1359F945704DD4D3FBB34C7BA8BD68C4E9C6358EA38B7F74CA2CC6 -->
