CellValue.IsError Property

Gets whether the cell contains an error.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v24.1.Core.dll

NuGet Package: DevExpress.Spreadsheet.Core

Declaration

C#

public bool IsError { get; }

VB.NET

Public ReadOnly Property IsError As Boolean

Property Value

Type	Description
Boolean	true, if the cell value is of the error type; otherwise, false

Remarks

You can also use the CellValue.Type property to obtain the cell value type. This property returns CellValueType.Error, if a cell value is an error.

To get the error value contained in a cell, use the CellValue.ErrorValue property. For more information on cell values, refer to the Cell Data Types document.

Related GitHub Examples

The following code snippets (auto-collected from DevExpress Examples) contain references to the IsError 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#

spreadsheet-document-api-export-worksheet-range-to-datatable/CS/ExportToDataTableWorkbookExample/MyConverter.cs#L18

}
if (cellValue.IsError) {
    // You can return an error, subsequently the exporter throws an exception if the CellValueConversionError event is unhandled.

how-to-export-cell-range-to-a-datatable/CS/ExportToDataTableExample/Form1.cs#L166

}
if (cellValue.IsError) {
    // You can return an error, subsequently the exporter throws an exception if the CellValueConversionError event is unhandled.

VB.NET

spreadsheet-document-api-export-worksheet-range-to-datatable/VB/ExportToDataTableWorkbookExample/MyConverter.vb#L20

End If
If cellValue.IsError Then
    ' You can return an error, subsequently the exporter throws an exception if the CellValueConversionError event is unhandled.

how-to-export-cell-range-to-a-datatable/VB/ExportToDataTableExample/Form1.vb#L156

If cellValue.IsError Then
    ' You can return an error, subsequently the exporter throws an exception if the CellValueConversionError event is unhandled.