# SpreadsheetAddressDialect

Identifies the address grammar used by a spreadsheet reference.

Enum 

`OfficeIMO.Spreadsheet`

**Namespace**

`OfficeIMO.Spreadsheet`

**Assembly**

`OfficeIMO.Core`

**Source revision**

`ba882f6b0d07` with working tree changes

**Source**

[SpreadsheetAddressSyntax.cs:7](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Core/Spreadsheet/SpreadsheetAddressSyntax.cs#L7)

**Base**

`Enum`

**Implements**

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

**Modifiers**

sealed

Identifies the address grammar used by a spreadsheet reference.

## Inheritance

- Enum
- SpreadsheetAddressDialect

## Usage

Explore 10 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 3

- Field [SpreadsheetAddressDialect.ExcelA1](/api/core/officeimo-spreadsheet-spreadsheetaddressdialect/#field-excela1)
- Field [SpreadsheetAddressDialect.OpenDocument](/api/core/officeimo-spreadsheet-spreadsheetaddressdialect/#field-opendocument)
- Field [SpreadsheetAddressDialect.UnboundedA1](/api/core/officeimo-spreadsheet-spreadsheetaddressdialect/#field-unboundeda1)

### Accepted by parameters 7

- Method [SpreadsheetRangeReference.Format](/api/core/officeimo-spreadsheet-spreadsheetrangereference/#method-format-officeimo-spreadsheet-spreadsheetaddressdialect) parameter `dialect`
- Method [SpreadsheetRangeReference.FormatBaseCell](/api/core/officeimo-spreadsheet-spreadsheetrangereference/#method-formatbasecell-officeimo-spreadsheet-spreadsheetaddressdialect) parameter `dialect`
- Method [SpreadsheetRangeReference.Parse](/api/core/officeimo-spreadsheet-spreadsheetrangereference/#method-parse-string-officeimo-spreadsheet-spreadsheetaddressdialect) parameter `dialect`
- Method [SpreadsheetRangeReference.TryFormat](/api/core/officeimo-spreadsheet-spreadsheetrangereference/#method-tryformat-officeimo-spreadsheet-spreadsheetaddressdialect-string) parameter `dialect`
- Method [SpreadsheetRangeReference.TryParse](/api/core/officeimo-spreadsheet-spreadsheetrangereference/#method-tryparse-string-officeimo-spreadsheet-spreadsheetaddressdialect-officeimo-spreadsheet-spreadsheetrangereference) parameter `dialect`
- Method [SpreadsheetReferenceSequence.Parse](/api/core/officeimo-spreadsheet-spreadsheetreferencesequence/#method-parse-string-officeimo-spreadsheet-spreadsheetaddressdialect) parameter `dialect`
- Method [SpreadsheetReferenceSequence.TryParse](/api/core/officeimo-spreadsheet-spreadsheetreferencesequence/#method-tryparse-string-officeimo-spreadsheet-spreadsheetaddressdialect-officeimo-spreadsheet-spreadsheetreferencesequence) parameter `dialect`

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 SpreadsheetAddressDialect ExcelA1` [#](#field-excela1)

[SpreadsheetAddressSyntax.cs:9](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Core/Spreadsheet/SpreadsheetAddressSyntax.cs#L9)

Excel A1 notation, for example 'Data'!$A$1:$B$2.

Value: `0`

`public const SpreadsheetAddressDialect OpenDocument` [#](#field-opendocument)

[SpreadsheetAddressSyntax.cs:12](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Core/Spreadsheet/SpreadsheetAddressSyntax.cs#L12)

OpenDocument address notation, for example $'Data'.$A$1:$'Data'.$B$2.

Value: `1`

`public const SpreadsheetAddressDialect UnboundedA1` [#](#field-unboundeda1)

[SpreadsheetAddressSyntax.cs:18](https://github.com/EvotecIT/OfficeIMO/blob/ba882f6b0d07acddd884b5e7d3086b0cfff0a05a/OfficeIMO.Core/Spreadsheet/SpreadsheetAddressSyntax.cs#L18)

A1 notation without Excel's fixed row and column limits. This is intended for bounded selections over spreadsheet formats whose grids can extend beyond Excel's worksheet size.

Value: `2`

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