CellRange.GetRangeWithRelativeReference() Method
In This Article
Returns the copy of the source range with its reference replaced by the relative reference.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v24.2.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
#Declaration
#Returns
Type | Description |
---|---|
Cell |
A Cell |
#Remarks
Use the CellRange.GetRangeWithAbsoluteReference method to convert the source range to the range with the absolute reference.
#Example
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();
See Also