DataValidationCollection.GetInvalidCells() Method

Returns cells that do not meet the data validation criteria.

Namespace: DevExpress.Spreadsheet

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

Declaration

C#

IEnumerable<Cell> GetInvalidCells()

VB.NET

Function GetInvalidCells As IEnumerable(Of Cell)

Returns

Type	Description
IEnumerable<Cell>	A IEnumerable<T><Cell,> collection of cells containing invalid data.

Remarks

Note that the GetInvalidCells property returns only first 255 invalid cells, other invalid entries are ignored. If there are no data validation errors in a worksheet, the GetInvalidCells property returns an empty collection.