All docs
V19.2
19.2
19.1
The page you are viewing does not exist in version 19.1. This link will take you to the root page.
18.2
The page you are viewing does not exist in version 18.2. This link will take you to the root page.
18.1
The page you are viewing does not exist in version 18.1. This link will take you to the root page.
17.2
The page you are viewing does not exist in version 17.2. This link will take you to the root page.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

CellRange.Name Property

Gets or sets the name of the cell range.

Namespace: DevExpress.Spreadsheet

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

Declaration

string Name { get; set; }
Property Name As String
string Name { get; set; }
Property Name As String
string Name { get; set; }
Property Name As String

Property Value

Type Description
String

A string that specifies the name associated with the cell range.

Property Value

Type Description
String

A string that specifies the name associated with the cell range.

Property Value

Type Description
String

A string that specifies the name associated with the cell range.

Remarks

To make is easier to refer to and use cell ranges (for example, in formulas), you can name them. To do this, set the Name property to the string, following the rules below:

  • Start a name with a letter, the "_" underscore symbol or the "" backslash. The rest of characters in a name can be letters, numbers, periods and underscore symbols. Note that a name cannot consist of only one of the following letters: "C", "c", "R", or "r".
  • A name cannot be the same as a cell reference (for example, "A1", "$M$15", etc.).
  • A name cannot contain spaces (use underscore symbols and periods instead).
  • A name cannot be an empty string.
  • The name length cannot exceed 255 characters.
  • Uppercase and lowercase letters are interpreted identically. For example, you are not allowed to create the Products and PRODUCTS names in one scope.

After you specify the Name property value, the corresponding DefinedName object is created and added to the Worksheet.DefinedNames collection of the worksheet that contains the named range (CellRange.Worksheet). Thus, this worksheet is the scope of the created name. The DefinedName.RefersTo property is automatically set to the absolute reference of the cell range (including the worksheet name).

When you use the Name property to obtain a name associated with the current range, the name is first searched for in the Worksheet.DefinedNames collection. If the name is not found in the worksheet, the search continues in the workbook's collection of defined names (IWorkbook.DefinedNames).

Refer to the Defined Names document for more information on defined names. For an example on the use of named ranges, see How to: Use Names in Formulas.

Examples

This example demonstrates how to create a named range of cells in a worksheet. You can do this in one of the following ways.

Note

When specifying a name for a cell or range of cells, follow the rules listed in the Defined Names document.

using DevExpress.Spreadsheet;
// ...

IWorkbook workbook = spreadsheetControl1.Document;
Worksheet worksheet = workbook.Worksheets[0];

// Create a range.
CellRange rangeA2A4 = worksheet.Range["A2:A4"];
// Specify the name for the created range.
rangeA2A4.Name = "rangeA2A4";

// Create a new defined name with the specifed range name and absolute reference.
DefinedName definedName = worksheet.DefinedNames.Add("rangeC2D3", "Sheet1!$C$2:$D$3");
// Create a range using the specified defined name.
CellRange rangeC2D3 = worksheet.Range[definedName.Name];
See Also