IXlCellError.Type Property
Gets the cell error type.
Namespace: DevExpress.Export.Xl
Assembly: DevExpress.Printing.v23.2.Core.dll
NuGet Package: DevExpress.Printing.Core
Declaration
Property Value
| Type | Description |
|---|---|
| XlCellErrorType | An XlCellErrorType enumeration member that specifies the error type. |
Available values:
| Name | Description |
|---|---|
| Null | The specified intersection includes two ranges that do not intersect. This error is indicated as #NULL!. |
| DivisionByZero | The formula includes division by zero or by a cell that does not contain any data. This error is indicated as #DIV/0!. |
| Value | The formula includes a value of the wrong data type. This error is indicated as #VALUE!. |
| Reference | The formula includes an invalid cell reference. This error is indicated as #REF!. |
| Name | The formula includes text that is not recognized (for example, a function name that is spelled incorrectly, a cell range reference without colon, etc.). This error is indicated as #NAME?. |
| Number | The formula or function includes invalid numeric values. This error is indicated as #NUM!. |
| NotAvailable | The value is not available to the formula or function. This error is indicated as #N/A. |
Remarks
The Type property allows you to get the type of the cell error. Use the IXlCellError.Description property to get the description of the error cause, and the IXlCellError.Name property to obtain the error name as it is displayed in a cell.