Class
ErrorExpressions

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:

cs-api-definition
public static class ErrorExpressions

Inheritance: objectErrorExpressions

Fields

CyclicReference

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

Declaration

cs-api-definition
public static readonly ErrorExpression CyclicReference

Field Value

ErrorExpression

DivisionByZero

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

Declaration

cs-api-definition
public static readonly ErrorExpression DivisionByZero

Field Value

ErrorExpression

NameError

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

Declaration

cs-api-definition
public static readonly ErrorExpression NameError

Field Value

ErrorExpression

NotAvailableError

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

Declaration

cs-api-definition
public static readonly ErrorExpression NotAvailableError

Field Value

ErrorExpression

NullError

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

Declaration

cs-api-definition
public static readonly ErrorExpression NullError

Field Value

ErrorExpression

NumberError

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

Declaration

cs-api-definition
public static readonly ErrorExpression NumberError

Field Value

ErrorExpression

ReferenceError

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

Declaration

cs-api-definition
public static readonly ErrorExpression ReferenceError

Field Value

ErrorExpression

ValueError

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

Declaration

cs-api-definition
public static readonly ErrorExpression ValueError

Field Value

ErrorExpression