DefinedName.Range Property

Gets or sets a cell range to which the defined name refers.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v23.2.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

CellRange Range { get; set; }

VB.NET

Property Range As CellRange

Property Value

Type	Description
CellRange	A CellRange object.

Remarks

Use the Range property to obtain an object that specifies a cell range associated with the defined name. If a defined name refers to a formula or constant, the Range property returns null (Nothing in VB). If a defined name refers to a relative range, the Range property gets a cell range relative to the A1 cell. For more information on defined names, see the Defined Names document.

Related GitHub Examples

The following code snippet (auto-collected from DevExpress Examples) contains a reference to the Range property.

Note

The algorithm used to collect these code examples remains a work in progress. Accordingly, the links and snippets below may produce inaccurate results. If you encounter an issue with code examples below, please use the feedback form on this page to report the issue.

C#

winforms-spreadsheet-use-custom-cell-editors/CS/DevAVInvoicing/Form1.cs#L186

sheet.Rows[rowIndex].Height = sheet.Rows[rowIndex + 1].Height;
CellRange range = invoiceItems.Range;
CellRange itemRange = sheet.Range.FromLTRB(range.LeftColumnIndex, range.BottomRowIndex, range.RightColumnIndex, range.BottomRowIndex);

VB.NET

winforms-spreadsheet-use-custom-cell-editors/VB/DevAVInvoicing/Form1.vb#L173

sheet.Rows(rowIndex).Height = sheet.Rows(rowIndex + 1).Height
Dim range As CellRange = invoiceItems.Range
Dim itemRange As CellRange = sheet.Range.FromLTRB(range.LeftColumnIndex, range.BottomRowIndex, range.RightColumnIndex, range.BottomRowIndex)