officefileapi-devexpress-dot-spreadsheet-dot-cellvalue-7beab04e.md
Gets whether the cell contains an error.
Namespace : DevExpress.Spreadsheet
Assembly : DevExpress.Spreadsheet.v25.2.Core.dll
NuGet Package : DevExpress.Spreadsheet.Core
public bool IsError { get; }
Public ReadOnly Property IsError As Boolean
| Type | Description |
|---|---|
| Boolean |
true , if the cell value is of the error type; otherwise, false
|
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.
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.
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.
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.
See Also