SharpCell

DiagnosticKind

public enum DiagnosticKind

Namespace SharpCell · package SharpCell

What a CalculationDiagnostic reports.

Values

Name Value Description
CircularReference 0 Cells reference each other in a loop; every cell in the loop got 0.
FunctionFailure 1 A function failed unexpectedly; the cell got #VALUE!.
UnsupportedFormula 2 A formula uses something SharpCell cannot evaluate, such as a function it does not know or (in a file) a link to another workbook; the cell got #NAME?.
LimitExceeded 3 A result was larger than a limit allows, such as the cells all spills of a workbook may cover together; the cell got an error.
CustomFunctionFailure 4 A function added through Workbook.Functions threw an exception; the cell got #VALUE!. The message names the function and the exception.
IterationLimitReached 5 With Workbook.Iteration enabled, a circular reference did not settle within IterationSettings.MaxIterations passes; its cells keep their last values.