SpreadsheetRangeReference
OfficeIMO.Spreadsheet
Immutable, typed spreadsheet address syntax. The parser understands quoting, absolute markers, whole-row and whole-column ranges without splitting semantic text on punctuation.
Inheritance
- object
- SpreadsheetRangeReference
Usage
Explore 5 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 4
Accepted by parameters 1
Methods
public string Format(SpreadsheetAddressDialect dialect) #Formats this address using the requested grammar.
Parameters
- dialect OfficeIMO.Spreadsheet.SpreadsheetAddressDialect
Returns
stringpublic string FormatBaseCell(SpreadsheetAddressDialect dialect) #Formats the first cell using the requested grammar.
Parameters
- dialect OfficeIMO.Spreadsheet.SpreadsheetAddressDialect
Returns
stringpublic static SpreadsheetRangeReference FromCell(int column, long row) #Creates a relative, unqualified single-cell address from one-based coordinates.
Parameters
- column int
- One-based column index.
- row long
- One-based row index.
Returns
SpreadsheetRangeReferencepublic static SpreadsheetRangeReference Parse(string text, SpreadsheetAddressDialect dialect) #Parses a complete address using the requested grammar.
Parameters
- text string
- dialect OfficeIMO.Spreadsheet.SpreadsheetAddressDialect
Returns
SpreadsheetRangeReferencepublic override string ToString() #Returns a string that represents the current object.
Returns
string A string that represents the current object.public bool TryFormat(SpreadsheetAddressDialect dialect, out string formatted) #Attempts to format this address without changing relative-sheet or cross-sheet range semantics.
Parameters
- dialect OfficeIMO.Spreadsheet.SpreadsheetAddressDialect
- formatted string
Returns
boolpublic static bool TryParse(string? text, SpreadsheetAddressDialect dialect, out SpreadsheetRangeReference? reference) #Attempts to parse a complete address using the requested grammar.
Parameters
- text string?
- dialect OfficeIMO.Spreadsheet.SpreadsheetAddressDialect
- reference OfficeIMO.Spreadsheet.SpreadsheetRangeReference?
Returns
bool