Table of Contents

ExcelErrorCode Enum

Definition

Namespace
Bodu.Formats.Excel
Assembly
Bodu.Formats.Excel.Binary.dll
Package
Bodu.Formats.Excel.Binary 1.0.0
Source
ExcelErrorCode.cs

Identifies the spreadsheet error value carried by an ExcelCell of kind Error. The underlying values match the error codes defined by the Excel binary file format, which are the same in BIFF5 and BIFF8.

public enum ExcelErrorCode : byte
Extension Methods

Fields

Null = 0

The intersection of two ranges that do not intersect (#NULL!).

DivideByZero = 7

A division by zero (#DIV/0!).

Value = 15

A value of the wrong type for an operation or function (#VALUE!).

Reference = 23

A reference to a cell that is not valid (#REF!).

Name = 29

An unrecognized name in a formula (#NAME?).

Number = 36

An invalid numeric value for a function or formula (#NUM!).

NotAvailable = 42

A value that is not available to a function or formula (#N/A).

Remarks

A cell whose stored error code is not one of the documented values is surfaced as that raw numeric value cast to this enumeration; compare against the named members before relying on the symbol.

Applies to

ProductVersions
.NET8, 10