GrapeCity.Documents.Excel.CalcError

Enum CalcError

Namespace

GrapeCity.Documents.Excel

Assembly

GcDocs.Excel.dll

Specifies the calculation error.

public enum CalcError

Fields

Blocked = 13

Indicates that the connection is blocked or prevented from being established.

Busy = 11

Indicates that a cell is calculating an async formula.

Calc = 10

Occurs when the calculation engine encounters a scenario it does not currently support.

Connect = 12

Indicates that the connection is failed or unable to be established.

Div0 = 2

Occurs when a formula attempts to divide by zero.

GettingData = 8

Indicates that an error occurred while retrieving data.

NA = 7

Indicates that a value is not available to a formula.

Name = 5

Occurs if Excel does not recognise a formula name or does not recognise text within a formula.

None = 0

Specifies no error.

Null = 1

Occurs when you refer to an intersection of two ranges that do not intersect.

Num = 6

Occurs when Excel encounters an invalid number.

Ref = 4

Occurs when a formula contains an invalid cell reference.

Spill = 9

Indicates that a formula returns multiple results, but can't return these values to neighboring cells.

Value = 3

Occurs if one of the variables in your formula is of the wrong type (e.g. text value when a numeric value is expected).