Skip to main content

XlCellErrorType Enum

Lists values used to specify the type of cell errors.

Namespace: DevExpress.Export.Xl

Assembly: DevExpress.Printing.v24.2.Core.dll

Declaration

public enum XlCellErrorType

Members

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.

Related API Members

The following properties accept/return XlCellErrorType values:

Remarks

The values listed by this enumeration are returned by the IXlCellError.Type property.

See Also