# SpreadsheetFormulaDialect

Identifies a supported spreadsheet formula grammar.

Enum 

`OfficeIMO.Spreadsheet`

**Namespace**

`OfficeIMO.Spreadsheet`

**Assembly**

`OfficeIMO.Core`

**Source revision**

`ba882f6b0d07` with working tree changes

**Source**

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

**Base**

`Enum`

**Implements**

`IComparable` `ISpanFormattable` `IFormattable` `IConvertible`

**Modifiers**

sealed

Identifies a supported spreadsheet formula grammar.

## Inheritance

- Enum
- SpreadsheetFormulaDialect

## Usage

Explore 7 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 5

- Field [SpreadsheetFormulaDialect.ExcelA1](/api/core/officeimo-spreadsheet-spreadsheetformuladialect/#field-excela1)
- Field [SpreadsheetFormulaDialect.OpenFormula](/api/core/officeimo-spreadsheet-spreadsheetformuladialect/#field-openformula)
- Property [SpreadsheetFormulaSyntaxTree.Dialect](/api/core/officeimo-spreadsheet-spreadsheetformulasyntaxtree/#property-dialect)
- Property [SpreadsheetFormulaTranslationResult.SourceDialect](/api/core/officeimo-spreadsheet-spreadsheetformulatranslationresult/#property-sourcedialect)
- Property [SpreadsheetFormulaTranslationResult.TargetDialect](/api/core/officeimo-spreadsheet-spreadsheetformulatranslationresult/#property-targetdialect)

### Accepted by parameters 2

- Method [SpreadsheetFormulaSyntaxTree.Parse](/api/core/officeimo-spreadsheet-spreadsheetformulasyntaxtree/#method-parse-string-officeimo-spreadsheet-spreadsheetformuladialect) parameter `dialect`
- Method [SpreadsheetFormulaSyntaxTree.TranslateTo](/api/core/officeimo-spreadsheet-spreadsheetformulasyntaxtree/#method-translateto-officeimo-spreadsheet-spreadsheetformuladialect) parameter `targetDialect`

Filter members 

Show inherited

## Inherited Methods

`public int CompareTo(object? target)` [#](#method-compareto-object)

Inherited from Enum

Parameters

**target object? required**

Returns

`int`

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

Inherited from Enum

Parameters

**obj object? required**

Returns

`bool`

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

Inherited from Enum

Returns

`int`

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

Inherited from object

Returns

`Type`

`public TypeCode GetTypeCode()` [#](#method-gettypecode)

Inherited from Enum

Returns

`TypeCode`

`public bool HasFlag(Enum flag)` [#](#method-hasflag-enum)

Inherited from Enum

Parameters

**flag Enum required**

Returns

`bool`

ToString 4 overloads

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

Inherited from Enum

Returns

`string`

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

Inherited from Enum

Parameters

**format string? required**

Returns

`string`

`public string ToString(IFormatProvider? provider)` [#](#method-tostring-iformatprovider)

Inherited from Enum

`Obsolete("The provider argument is not used. Use ToString() instead.")`

Parameters

**provider IFormatProvider? required**

Returns

`string`

`public string ToString(string? format, IFormatProvider? provider)` [#](#method-tostring-string-iformatprovider)

Inherited from Enum

`Obsolete("The provider argument is not used. Use ToString(String) instead.")`

Parameters

**format string? required**

**provider IFormatProvider? required**

Returns

`string`

## Values

`public const SpreadsheetFormulaDialect ExcelA1` [#](#field-excela1)

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

Excel invariant A1 formula syntax.

Value: `0`

`public const SpreadsheetFormulaDialect OpenFormula` [#](#field-openformula)

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

OASIS OpenFormula syntax used by OpenDocument spreadsheets.

Value: `1`

<!-- PowerForge markdown artifact sha256:EE51EBDE60BE7A6C3AF4350ACE940EE393084DAB8C9E235E29274A8DC6E405E3 -->
