Back to Devexpress

XlCellErrorType Enum

corelibraries-devexpress-dot-export-dot-xl-249889b7.md

latest1.9 KB
Original Source

XlCellErrorType Enum

Lists values used to specify the type of cell errors.

Namespace : DevExpress.Export.Xl

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

NuGet Package : DevExpress.Printing.Core

Declaration

csharp
public enum XlCellErrorType
vb
Public Enum XlCellErrorType

Members

NameDescription
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.

|

The following properties accept/return XlCellErrorType values:

Remarks

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

See Also

DevExpress.Export.Xl Namespace