The requested page is not available for the requested platform. You are viewing the content for .NET Framework 4.5.2+ platform.
.NET Framework 4.5.2+
.NET Framework 4.5.2+
.NET Standard 2.0+
.NET Core 3.0+
Row

ErrorType Enum

Lists errors that can occur in cells.

Namespace: DevExpress.Spreadsheet

Assembly: DevExpress.Spreadsheet.v19.2.Core.dll

Declaration

public enum ErrorType
Public Enum ErrorType
public enum ErrorType
Public Enum ErrorType
public enum ErrorType
Public Enum ErrorType

Members

Name Description
DivisionByZero

The formula includes division by zero or by a cell that does not contain any data. This error is indicated as #DIV/0!.

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

None

There is no error in the cell.

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

Number

The formula or function includes invalid numeric values. This error is indicated as #NUM!.

Reference

The formula include an invalid cell reference. This error is indicated as #REF!.

Value

The formula includes a value of the wrong data type. This error is indicated as #VALUE!.

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 ErrorValueInfo.Type property returns ErrorType enumeration member that specifies an error type.

For more information on cell values, see the Cell Data Types document.

See Also