officefileapi-devexpress-dot-spreadsheet-dot-cellrange-d1585485.md
Returns the copy of the source range with its reference replaced by the relative reference.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
CellRange GetRangeWithRelativeReference()
Function GetRangeWithRelativeReference As CellRange
| Type | Description |
|---|---|
| CellRange |
A CellRange object with the relative reference.
|
Use the CellRange.GetRangeWithAbsoluteReference method to convert the source range to the range with the absolute reference.
This example demonstrates how to use the CellRange.GetRangeWithAbsoluteReference and CellRange.GetRangeWithRelativeReference methods to get a range object with the source range reference converted to the absolute or relative reference, respectively.
using DevExpress.Spreadsheet;
// ...
Worksheet worksheet = spreadsheetControl.Document.Worksheets[0];
CellRange range = worksheet.Range["A$1:B$5"];
// Return the range with the absolute range reference - "$A$1:$B$5".
CellRange absRange = range.GetRangeWithAbsoluteReference();
// Return the range with the relative range reference - "A1:B5".
CellRange relRange = range.GetRangeWithRelativeReference();
Imports DevExpress.Spreadsheet
' ...
Dim worksheet As Worksheet = spreadsheetControl.Document.Worksheets(0)
Dim range As CellRange = worksheet.Range("A$1:B$5")
' Return the range with the absolute range reference - "$A$1:$B$5".
Dim absRange As CellRange = range.GetRangeWithAbsoluteReference()
' Return the range with the relative range reference - "A1:B5".
Dim relRange As CellRange = range.GetRangeWithRelativeReference()
See Also