# SpreadsheetFormulaTranslationResult

Result of translating a typed spreadsheet formula syntax tree.

Class 

`OfficeIMO.Spreadsheet`

**Namespace**

`OfficeIMO.Spreadsheet`

**Assembly**

`OfficeIMO.Core`

**Source revision**

`ba882f6b0d07` with working tree changes

**Source**

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

**Modifiers**

sealed

Result of translating a typed spreadsheet formula syntax tree.

## Inheritance

- object
- SpreadsheetFormulaTranslationResult

## 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.TranslateTo](/api/core/officeimo-spreadsheet-spreadsheetformulasyntaxtree/#method-translateto-officeimo-spreadsheet-spreadsheetformuladialect)

Filter members 

Show inherited

## Methods

`public string RequireFormula()` [#](#method-requireformula)

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

Returns the translated formula or throws when safe translation was not possible.

Returns

`string`

## 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 Formula { get; }` [#](#property-formula)

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

Gets the translated formula candidate.

`public SpreadsheetFormulaDialect SourceDialect { get; }` [#](#property-sourcedialect)

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

Gets the source grammar.

`public SpreadsheetFormulaDialect TargetDialect { get; }` [#](#property-targetdialect)

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

Gets the destination grammar.

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

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

Gets parse and translation findings.

`public bool IsSuccessful { get; }` [#](#property-issuccessful)

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

Gets whether the candidate is safe to emit.

<!-- PowerForge markdown artifact sha256:8CE17333C2CA4F1E7CA7AAA054840ABD710F190BC55ED94F867B10A37E82244B -->
