[]
Specifies the calculation error.
public enum CalcError
Blocked = 13Indicates that the connection is blocked or prevented from being established.
Busy = 11Indicates that a cell is calculating an async formula.
Calc = 10Occurs when the calculation engine encounters a scenario it does not currently support.
Connect = 12Indicates that the connection is failed or unable to be established.
Div0 = 2Occurs when a formula attempts to divide by zero.
GettingData = 8Indicates that an error occurred while retrieving data.
NA = 7Indicates that a value is not available to a formula.
Name = 5Occurs if Excel does not recognise a formula name or does not recognise text within a formula.
None = 0Specifies no error.
Null = 1Occurs when you refer to an intersection of two ranges that do not intersect.
Num = 6Occurs when Excel encounters an invalid number.
Ref = 4Occurs when a formula contains an invalid cell reference.
Spill = 9Indicates that a formula returns multiple results, but can't return these values to neighboring cells.
Value = 3Occurs if one of the variables in your formula is of the wrong type (e.g. text value when a numeric value is expected).