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.ExistingCells Property

Gets the existing cells in the current cell range.

Namespace: DevExpress.Spreadsheet

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

Declaration

IEnumerable<Cell> ExistingCells { get; }
ReadOnly Property ExistingCells As IEnumerable(Of Cell)
IEnumerable<Cell> ExistingCells { get; }
ReadOnly Property ExistingCells As IEnumerable(Of Cell)
IEnumerable<Cell> ExistingCells { get; }
ReadOnly Property ExistingCells As IEnumerable(Of Cell)

Property Value

Type Description
IEnumerable<Cell>

An object implementing the IEnumerable interface that supports iteration over the cell collection.

Property Value

Type Description
IEnumerable<Cell>

An object implementing the IEnumerable interface that supports iteration over the cell collection.

Property Value

Type Description
IEnumerable<Cell>

An object implementing the IEnumerable interface that supports iteration over the cell collection.

Remarks

The ExistingCells collection includes the following cells:

  • Cells that contain a CellRange.Value or CellRange.Formula;
  • Cells that have any Formatting properties which are not null;
  • Top-left cells of merged cells;
  • Cells that contained a value or had cell formatting options applied at any time. For example, if the cell A1 contained a value that was later deleted, the cell A1 is included in the ExistingCells collection.

To get a collection of existing cells in a worksheet, use the Worksheet.GetExistingCells method.

See Also