New to Telerik Document Processing? Start a free 30-day trial

ErrorType

Class

Implements the ERROR.TYPE function, which maps error values to numeric codes (1-7) and returns #N/A if no error exists.

Definition

Namespace:Telerik.Documents.Spreadsheet.Expressions.Functions

Assembly:Telerik.Windows.Documents.Spreadsheet.dll

Syntax:

public class ErrorType : FunctionBase

Inheritance: objectFunctionBaseErrorType

Inherited Members FunctionBase.IsSpillingArgument(int, RadExpression)FunctionBase.Evaluate(FunctionEvaluationContext<RadExpression>)FunctionBase.EvaluateLiftedElement(FunctionEvaluationContext<RadExpression>, RadExpression[], int, int)FunctionBase.IsArgumentNumberValid(int)FunctionBase.ArgumentConversionRules

Constructors

ErrorType()

Initializes the ERROR.TYPE function, which identifies error types and returns their numeric classification.

public ErrorType()

Fields

FunctionName

string

The name of the function.

public static readonly string FunctionName

Properties

FunctionInfo

Gets the metadata describing the function's signature, including the required error value argument.

public override FunctionInfo FunctionInfo { get; }

Property Value:

The function info as FunctionInfo.

Overrides: FunctionBase.FunctionInfo

When true, FunctionBase automatically evaluates this function element-wise over any multi-element array argument and returns a spilled array result. Override to true in pure scalar functions (e.g. ABS, LEN, MOD) where applying the function independently to each element of an input array is the correct dynamic-array behavior. Leave false (the default) for reducers.

public override bool LiftsOverArrays { get; }

Overrides: FunctionBase.LiftsOverArrays

Name

string

Gets the function name "ERROR.TYPE" for use in formulas.

public override string Name { get; }

Property Value:

The name as String.

Overrides: FunctionBase.Name

Methods

EvaluateOverride(FunctionEvaluationContext<RadExpression>)

Evaluates the error type argument and returns the corresponding numeric code (1=#NULL!, 2=#DIV/0!, 3=#VALUE!, 4=#REF!, 5=#NAME?, 6=#NUM!, 7=#N/A) or #N/A if not an error.

protected override RadExpression EvaluateOverride(FunctionEvaluationContext<RadExpression> context)

Parameters:contextFunctionEvaluationContext<RadExpression>

The context.

Returns:

RadExpression

Function result as RadExpression.

Overrides: FunctionBase.EvaluateOverride(FunctionEvaluationContext<RadExpression>)