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