SharpCell

ErrorKind

public enum ErrorKind

Namespace SharpCell · package SharpCell

Excel error values. Numeric values match the codes returned by ERROR.TYPE.

Values

Name Value Description
Null 1 #NULL!: the intersection of two ranges is empty.
Div0 2 #DIV/0!: division by zero.
Value 3 #VALUE!: an argument has the wrong type.
Ref 4 #REF!: a reference is not valid.
Name 5 #NAME?: an unknown function or name.
Num 6 #NUM!: a number is out of range or a calculation does not converge.
NA 7 #N/A: a value is not available, such as a lookup that found nothing.
Spill 9 #SPILL!: a dynamic array result cannot spill because cells are in the way.
Calc 14 #CALC!: the calculation cannot produce a result, such as an empty array.