Range.GetRangeWithRelativeReference() Method

Returns the copy of the source range with its reference replaced by the relative reference.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.1.Core.dll

Declaration

C#

Range GetRangeWithRelativeReference()

VB.NET

Function GetRangeWithRelativeReference As Range

Returns

Type	Description
Range	A Range object with the relative reference.

Remarks

Use the Range.GetRangeWithAbsoluteReference method to convert the source range to the range with the absolute reference.

Example

This example demonstrates how to use the Range.GetRangeWithAbsoluteReference and Range.GetRangeWithRelativeReference methods to get a range object with the source range reference converted to the absolute or relative reference, respectively.

C#

using DevExpress.Spreadsheet;
// ...

Worksheet worksheet = spreadsheetControl.Document.Worksheets[0];
Range range = worksheet.Range["A$1:B$5"];

// Return the range with the absolute range reference - "$A$1:$B$5".
Range absRange = range.GetRangeWithAbsoluteReference();

// Return the range with the relative range reference - "A1:B5".
Range relRange = range.GetRangeWithRelativeReference();

VB.NET

Imports DevExpress.Spreadsheet
' ...

Dim worksheet As Worksheet = spreadsheetControl.Document.Worksheets(0)
Dim range As Range = worksheet.Range("A$1:B$5")

' Return the range with the absolute range reference - "$A$1:$B$5".
Dim absRange As Range = range.GetRangeWithAbsoluteReference()

' Return the range with the relative range reference - "A1:B5".
Dim relRange As Range = range.GetRangeWithRelativeReference()