Enum
SpreadsheetAddressDialect
OfficeIMO.Spreadsheet
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
Accepted by parameters 7
Inherited Methods
ToString 4 overloads
public string ToString(IFormatProvider? provider) #Inherited from Enum
Obsolete("The provider argument is not used. Use ToString() instead.")Parameters
- provider IFormatProvider?
Returns
stringpublic string ToString(string? format, IFormatProvider? provider) #Inherited from Enum
Obsolete("The provider argument is not used. Use ToString(String) instead.")Parameters
- format string?
- provider IFormatProvider?
Returns
stringValues
public const SpreadsheetAddressDialect ExcelA1 #Excel A1 notation, for example 'Data'!$A$1:$B$2.
Value:
0public const SpreadsheetAddressDialect OpenDocument #OpenDocument address notation, for example $'Data'.$A$1:$'Data'.$B$2.
Value:
1public const SpreadsheetAddressDialect UnboundedA1 #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