NanoXLSX.Core 3.2.1
Loading...
Searching...
No Matches
NanoXLSX.Enums.Errors Class Reference

Static class that contains shared enums for error cases. More...

Public Types

enum  FormulaError {
  NoError , UnknownError , Null , DivisionByZero ,
  Value , Reference , Name , Number ,
  NotAvailable , GettingData
}
 Errors that can occur in formulas / functions. More...

Detailed Description

Static class that contains shared enums for error cases.

Definition at line 15 of file Errors.cs.

Member Enumeration Documentation

◆ FormulaError

Errors that can occur in formulas / functions.

Enumerator
NoError 

Default value if no error has occurred (not an actual error type).

UnknownError 

Value if a not yet defined value has occurred (not an actual error type).

Null 

Indicates that two areas are required to intersect, but do not.

DivisionByZero 

Indicates that any number (including zero) or any error code is divided by zero.

Value 

Indicates that an incompatible type argument is passed to a function, or an incompatible type operand is used with an operator.

Reference 

Indicate that a cell reference cannot be evaluated.

Name 

Indicates that what looks like a name is used, but no such name has been defined.

Number 

Indicates that 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
This is known as a domain error. In contrast to FormulaError.Value, a formula or function may look valid, but tries to handle an invalid value of the valid type. Example: ATANH(50)
NotAvailable 

Indicates that a designated value is not available.

Remarks
Can (f.e.) happen if a formula requires two arrays of the same length, but the provided ones have different lengths. Example: SUMX2MY2(A1:A3;B1:B4)
GettingData 

Indicate that a cell reference cannot be evaluated because the value for the cell has not been retrieved or calculated.

Remarks
In contrast to FormulaError.NotAvailable, the value will eventually be available (e.g. by an external source).

Definition at line 20 of file Errors.cs.


The documentation for this class was generated from the following file: