GrapeCity.Documents.Excel.CalcError

CalcError Enum

Specifies the calculation error.

Use this enum when reading or assigning formula error values, such as #DIV/0!, #VALUE!, or #N/A.

Namespace: GrapeCity.Documents.Excel

Assembly: DS.Documents.Excel.dll

Syntax

public enum CalcError

Public Enum CalcError

Examples

Workbook workbook = new Workbook();
IWorksheet worksheet = workbook.ActiveSheet;
worksheet.Range["A1"].Formula = "=1/0";
CalcError error = (CalcError)worksheet.Range["A1"].Value;

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