pub enum ExcelError {
DivZero,
NA,
Name,
Null,
Num,
Ref,
Value,
}Expand description
The seven Excel worksheet error values, in #LITERAL! form.
Variants§
DivZero
#DIV/0! — division by zero, including MOD(x, 0),
0^-1, and AVERAGE/STDEV/VAR over zero numeric values.
NA
#N/A — “no value available”: lookup misses (VLOOKUP, MATCH),
the #N/A literal, ISNA.
Name
#NAME? — unrecognized name text. In this crate the literal
#NAME? propagates as a value; unknown function names are a hard
FormulaError::UnknownFunction instead (see the crate docs for
the rationale).
Null
#NULL! — the empty-intersection error. Also the crate’s canonical
omitted-argument marker: IF(A1,,5) stores Error(Null) in the
AST for the empty second slot (see crate::is_omitted_arg).
Num
#NUM! — a numeric problem: overflow to ±inf/NaN, SQRT(-1),
LOG of a non-positive number, POWER(0, 0), sign-mismatched
CEILING/FLOOR, a date serial outside 1900-9999.
Ref
#REF! — an invalid reference: out-of-grid OFFSET, an INDEX
position past the edge of its range, a VLOOKUP column index wider
than the table, the #REF! literal.
Value
#VALUE! — wrong type for the operation: arithmetic on
non-numeric text, MID with a zero start, REPT with a negative
count, wrong argument counts, a 2-D MATCH vector.