Skip to main content

ExcelError

Enum ExcelError 

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

Implementations§

Source§

impl ExcelError

Source

pub const fn literal(self) -> &'static str

The Excel worksheet literal for this error ("#DIV/0!", "#N/A", …).

Source

pub fn from_literal(lit: &str) -> Option<Self>

Parses an Excel error literal ("#DIV/0!", "#n/a", …), case-insensitively. Returns None for anything else.

Trait Implementations§

Source§

impl Clone for ExcelError

Source§

fn clone(&self) -> Self

Returns a duplicate of the value. Read more
1.0.0 (const: unstable) · Source§

fn clone_from(&mut self, source: &Self)

Performs copy-assignment from source. Read more
Source§

impl Copy for ExcelError

Source§

impl Debug for ExcelError

Source§

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter. Read more
Source§

impl Display for ExcelError

Source§

fn fmt(&self, f: &mut Formatter<'_>) -> Result

Formats the value using the given formatter. Read more
Source§

impl Eq for ExcelError

Source§

impl From<ExcelError> for FormulaError

Source§

fn from(e: ExcelError) -> Self

Converts to this type from the input type.
Source§

impl Hash for ExcelError

Source§

fn hash<__H: Hasher>(&self, state: &mut __H)

Feeds this value into the given Hasher. Read more
1.3.0 · Source§

fn hash_slice<H>(data: &[Self], state: &mut H)
where H: Hasher, Self: Sized,

Feeds a slice of this type into the given Hasher. Read more
Source§

impl PartialEq for ExcelError

Source§

fn eq(&self, other: &Self) -> bool

Equality operator ==. Read more
1.0.0 (const: unstable) · Source§

fn ne(&self, other: &Rhs) -> bool

Inequality operator !=. Read more
Source§

impl StructuralPartialEq for ExcelError

Auto Trait Implementations§

Blanket Implementations§

Source§

impl<T> Any for T
where T: 'static + ?Sized,

Source§

fn type_id(&self) -> TypeId

Gets the TypeId of self. Read more
Source§

impl<T> Borrow<T> for T
where T: ?Sized,

Source§

fn borrow(&self) -> &T

Immutably borrows from an owned value. Read more
Source§

impl<T> BorrowMut<T> for T
where T: ?Sized,

Source§

fn borrow_mut(&mut self) -> &mut T

Mutably borrows from an owned value. Read more
Source§

impl<T> CloneToUninit for T
where T: Clone,

Source§

unsafe fn clone_to_uninit(&self, dest: *mut u8)

🔬This is a nightly-only experimental API. (clone_to_uninit)
Performs copy-assignment from self to dest. Read more
Source§

impl<T> From<T> for T

Source§

fn from(t: T) -> T

Returns the argument unchanged.

Source§

impl<T, U> Into<U> for T
where U: From<T>,

Source§

fn into(self) -> U

Calls U::from(self).

That is, this conversion is whatever the implementation of From<T> for U chooses to do.

Source§

impl<T> ToOwned for T
where T: Clone,

Source§

type Owned = T

The resulting type after obtaining ownership.
Source§

fn to_owned(&self) -> T

Creates owned data from borrowed data, usually by cloning. Read more
Source§

fn clone_into(&self, target: &mut T)

Uses borrowed data to replace owned data, usually by cloning. Read more
Source§

impl<T> ToString for T
where T: Display + ?Sized,

Source§

fn to_string(&self) -> String

Converts the given value to a String. Read more
Source§

impl<T, U> TryFrom<U> for T
where U: Into<T>,

Source§

type Error = !

The type returned in the event of a conversion error.
Source§

fn try_from(value: U) -> Result<T, !>

Performs the conversion.
Source§

impl<T, U> TryInto<U> for T
where U: TryFrom<T>,

Source§

type Error = <U as TryFrom<T>>::Error

The type returned in the event of a conversion error.
Source§

fn try_into(self) -> Result<U, <U as TryFrom<T>>::Error>

Performs the conversion.