Table of Contents

Enum XLError

Namespace
SlapKit.Excel.Excel
Assembly
SlapKit.Excel.dll

A formula error.

public enum XLError
Extension Methods

Fields

CellReference = 3

#REF! - a formula refers to a cell that's not valid.

DivisionByZero = 1

#DIV/0! - Intended to indicate when any number (including zero) or any error code is divided by zero.

IncompatibleValue = 2

#VALUE! - Intended to indicate when an incompatible type argument is passed to a function, or an incompatible type operand is used with an operator.

NameNotRecognized = 4

#NAME? - Intended to indicate when what looks like a name is used, but no such name has been defined.

NoValueAvailable = 6

#N/A - Intended to indicate when a designated value is not available.

NullValue = 0

#NULL! - Intended to indicate when two areas are required to intersect, but do not.

NumberInvalid = 5

#NUM! - Intended to indicate when an argument to a function has a compatible type, but has a value that is outside the domain over which that function is defined.

Remarks

Keep order of errors in same order as value returned by ERROR.TYPE, because it is used for comparison in some case (e.g. AutoFilter). Values are off by 1, so default produces a valid error.