constructor

• new ErrorValue(a): ErrorValue

• Parameters

  • a: number

  Returns ErrorValue

Static $t

Static argumentOrFunctionNotAvailable

• get argumentOrFunctionNotAvailable(): ErrorValue

• Gets the ErrorValue representing the #N/A error.

  This error occurs when a value isn't available for some part of a formula.

  The ErrorValue representing the #N/A error.

  Returns ErrorValue

Static circularity

• get circularity(): ErrorValue

• Gets the ErrorValue representing a circularity error.

  There is no error constant for a circularity in Microsoft Excel and a circularity cannot be the result of a formula in Microsoft Excel. However, for run-time purposes, after loading or before saving a workbook, this error value will be used for the result of formulas which cause circular references when the owning workbook has [[Workbook.iterativeCalculationsEnabled]] set to False.

  In Microsoft Excel, setting a circular reference formula on a cell will show an error dialog the first time the problem occurs. Subsequent formulas violating the circular reference restriction will just evaluate to zero. Therefore, when this value is encountered in a cell, it can be treated as a zero for calculation purposes. This error value will be returned though so an actual zero value in a cell can be differentiated from a circularity error.

  Note: Because there is no circularity error constant in Microsoft Excel, this error value cannot be assigned to a cell manually. Attempting to assign this error value to a cell will result in an InvalidOperationException to be thrown. This error value will only be valid as the result of a formula which has been applied to a cell.

  The ErrorValue representing a circularity error.

  Returns ErrorValue

Static divisionByZero

• get divisionByZero(): ErrorValue

• Gets the ErrorValue representing the #DIV/0! error.

  This error occurs when a number is divided by zero.

  The ErrorValue representing the #DIV/0! error.

  Returns ErrorValue

Static emptyCellRangeIntersection

• get emptyCellRangeIntersection(): ErrorValue

• Gets the ErrorValue representing the #NULL! error.

  This error occurs when there is an intersection of two references that do not contain any common cells. The intersection operator is a space between two references.

  The ErrorValue representing the #NULL! error.

  Returns ErrorValue

Static invalidCellReference

• get invalidCellReference(): ErrorValue

• Gets the ErrorValue representing the #REF! error.

  This error occurs when a cell reference or cell range reference is not valid.

  The ErrorValue representing the #REF! error.

  Returns ErrorValue

Static valueRangeOverflow

• get valueRangeOverflow(): ErrorValue

• Gets the ErrorValue representing the #NUM! error.

  This error occurs when there are invalid numeric values in a formula.

  The ErrorValue representing the #NUM! error.

  Returns ErrorValue

Static wrongFunctionName

• get wrongFunctionName(): ErrorValue

• Gets the ErrorValue representing the #NAME? error.

  This error occurs when text in a formula is not recognized.

  The ErrorValue representing the #NAME? error.

  Returns ErrorValue

Static wrongOperandType

• get wrongOperandType(): ErrorValue

• Gets the ErrorValue representing the #VALUE! error.

  This error occurs when an incorrect argument or operand is used in a function.

  The ErrorValue representing the #VALUE! error.

  Returns ErrorValue

toString

• toString(): string

• Gets the string representation of the error value.

  Returns string