[]
        
(Showing Draft Content)

GrapeCity.Documents.Excel.CalcError

CalcError Enum

Specifies the calculation error.

Namespace: GrapeCity.Documents.Excel
Assembly: DS.Documents.Excel.dll
Syntax
public enum CalcError
Public Enum CalcError

Fields

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