Class ErrorValue

Represents an error value in Microsoft Excel.

Inheritance

System.Object

ErrorValue

Namespace: Infragistics.Documents.Excel

Assembly: IgniteUI.Blazor.Documents.Excel.dll

Syntax

public class ErrorValue : Object

Properties

ArgumentOrFunctionNotAvailable

Gets the ErrorValue representing the #N/A error.

Declaration

public static ErrorValue ArgumentOrFunctionNotAvailable { get; }

Property Value

Type	Description
ErrorValue	The ErrorValue representing the #N/A error.

Remarks

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

Circularity

Gets the ErrorValue representing a circularity error.

Declaration

public static ErrorValue Circularity { get; }

Property Value

Type	Description
ErrorValue	The ErrorValue representing a circularity error.

Remarks

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

DivisionByZero

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

Declaration

public static ErrorValue DivisionByZero { get; }

Property Value

Type	Description
ErrorValue	The ErrorValue representing the #DIV/0! error.

Remarks

This error occurs when a number is divided by zero.

EmptyCellRangeIntersection

Gets the ErrorValue representing the #NULL! error.

Declaration

public static ErrorValue EmptyCellRangeIntersection { get; }

Property Value

Type	Description
ErrorValue	The ErrorValue representing the #NULL! error.

Remarks

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.

InvalidCellReference

Gets the ErrorValue representing the #REF! error.

Declaration

public static ErrorValue InvalidCellReference { get; }

Property Value

Type	Description
ErrorValue	The ErrorValue representing the #REF! error.

Remarks

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

ValueRangeOverflow

Gets the ErrorValue representing the #NUM! error.

Declaration

public static ErrorValue ValueRangeOverflow { get; }

Property Value

Type	Description
ErrorValue	The ErrorValue representing the #NUM! error.

Remarks

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

WrongFunctionName

Gets the ErrorValue representing the #NAME? error.

Declaration

public static ErrorValue WrongFunctionName { get; }

Property Value

Type	Description
ErrorValue	The ErrorValue representing the #NAME? error.

Remarks

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

WrongOperandType

Gets the ErrorValue representing the #VALUE! error.

Declaration

public static ErrorValue WrongOperandType { get; }

Property Value

Type	Description
ErrorValue	The ErrorValue representing the #VALUE! error.

Remarks

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

Methods

ToString()

Gets the string representation of the error value.

Declaration

public override string ToString()

Returns

Type	Description
System.String	The string representation of the error value.