New to Telerik Document ProcessingStart a free 30-day trial

Provides standard error expression instances for common formula errors such as #DIV/0!, #VALUE!, #REF!, and #N/A, matching Excel error semantics.

Definition

Namespace:Telerik.Windows.Documents.Spreadsheet.Expressions

Assembly:Telerik.Windows.Documents.Spreadsheet.dll

Syntax:

C#
public static class ErrorExpressions

Inheritance: objectErrorExpressions

Fields

Error indicating a circular dependency was detected where a formula references itself directly or indirectly.

C#
public static readonly ErrorExpression CyclicReference

#DIV/0! error indicating division by zero was attempted.

C#
public static readonly ErrorExpression DivisionByZero

#NAME? error indicating an unrecognized function or range name.

C#
public static readonly ErrorExpression NameError

#N/A error indicating a value is not available, commonly used in lookup functions when no match is found.

C#
public static readonly ErrorExpression NotAvailableError

#NULL! error indicating an invalid range intersection or missing range operator.

C#
public static readonly ErrorExpression NullError

#NUM! error indicating an invalid numeric value or out-of-range calculation result.

C#
public static readonly ErrorExpression NumberError

#REF! error indicating an invalid cell reference, often from deleted rows or columns.

C#
public static readonly ErrorExpression ReferenceError

#VALUE! error indicating an invalid value type or operand mismatch in a formula.

C#
public static readonly ErrorExpression ValueError