ErrorValueInfo.Type Property
Gets the type of the error that occurred in the cell.
Namespace: DevExpress.Spreadsheet
Assembly: DevExpress.Spreadsheet.v23.2.Core.dll
NuGet Package: DevExpress.Spreadsheet.Core
Declaration
Property Value
| Type | Description |
|---|---|
| ErrorType | An ErrorType enumeration member that specifies the error type. |
Available values:
| Name | Description |
|---|---|
| None | There is no error in the cell. |
| Value | The formula includes a value of the wrong data type. This error is indicated as #VALUE!. |
| DivisionByZero | The formula includes division by zero or by a cell that does not contain any data. This error is indicated as #DIV/0!. |
| Number | The formula or function includes invalid numeric values. This error is indicated as #NUM!. |
| Name | The formula includes text that is not recognized (for example, a defined name that does not exist, a function name that is spelled incorrectly, a cell range reference without colon, etc.). This error is indicated as #NAME?. |
| Reference | The formula include an invalid cell reference. This error is indicated as #REF!. |
| NotAvailable | The value is not available to the formula or function. This error is indicated as #N/A. |
| Null | The specified intersection includes two ranges that do not intersect. This error is indicated as #NULL!. |
Remarks
If a cell contains a formula that cannot be calculated correctly, this cell displays an error. In this case, the cell value‘s CellValue.IsError property returns true and the CellValue.ErrorValue property returns the ErrorValueInfo object that provides information on the error that occurred in the cell. The Type property gets the error type, the ErrorValueInfo.Name property gets the error name (error code) that is displayed in the cell, and the ErrorValueInfo.Description property gets the description of the error’s cause.
The Error Types document provides the full list of all possible errors that can occur in cell formulas.