Class ErrorExpressions

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

Inheritance

System.Object

ErrorExpressions

Inherited Members

System.Object.ToString()

System.Object.Equals(System.Object)

System.Object.Equals(System.Object, System.Object)

System.Object.ReferenceEquals(System.Object, System.Object)

System.Object.GetHashCode()

System.Object.GetType()

System.Object.MemberwiseClone()

Namespace: Telerik.Windows.Documents.Spreadsheet.Expressions

Assembly: Telerik.Windows.Documents.Spreadsheet.dll

Syntax

public static class ErrorExpressions

Fields

CyclicReference

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

Declaration

public static readonly ErrorExpression CyclicReference

Field Value

ErrorExpression

DivisionByZero

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

Declaration

public static readonly ErrorExpression DivisionByZero

Field Value

ErrorExpression

NameError

NAME? error indicating an unrecognized function or range name.

Declaration

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

public static readonly ErrorExpression NotAvailableError

Field Value

ErrorExpression

NullError

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

Declaration

public static readonly ErrorExpression NullError

Field Value

ErrorExpression

NumberError

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

Declaration

public static readonly ErrorExpression NumberError

Field Value

ErrorExpression

ReferenceError

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

Declaration

public static readonly ErrorExpression ReferenceError

Field Value

ErrorExpression

ValueError

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

Declaration

public static readonly ErrorExpression ValueError

Field Value

ErrorExpression