Skip to main content
A newer version of this page is available. .

XlCellErrorType Enum

Lists values used to specify the type of cell errors.

Namespace: DevExpress.Export.Xl

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

NuGet Packages: DevExpress.Printing.Core, DevExpress.WindowsDesktop.Printing.Core

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