New to Telerik Document ProcessingStart a free 30-day trial

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.Windows.Documents.Spreadsheet.Expressions.Functions

Assembly:Telerik.Windows.Documents.Spreadsheet.dll

Syntax:

C#
public class ErrorType : FunctionBase

Inheritance: objectFunctionBaseErrorType

Inherited Members FunctionBase.Evaluate(FunctionEvaluationContext<RadExpression>)FunctionBase.IsArgumentNumberValid(int)FunctionBase.ArgumentConversionRules

Constructors

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

C#
public ErrorType()

Fields

The name of the function.

C#
public static readonly string FunctionName

Methods

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.

C#
protected override RadExpression EvaluateOverride(FunctionEvaluationContext<RadExpression> context)
Parameters:contextFunctionEvaluationContext<RadExpression>

The context.

Returns:

RadExpression

Function result as RadExpression.

Overrides: FunctionBase.EvaluateOverride(FunctionEvaluationContext<RadExpression>)

Properties

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

C#
public override FunctionInfo FunctionInfo { get; }
Property Value:

The function info as FunctionInfo.

Overrides: FunctionBase.FunctionInfo

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

C#
public override string Name { get; }
Property Value:

The name as String.

Overrides: FunctionBase.Name