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

Match

Class

Implements the MATCH function, which searches for a value in a range and returns its relative position within that range.

Definition

Namespace:Telerik.Documents.Spreadsheet.Expressions.Functions.LookupAndReference

Assembly:Telerik.Windows.Documents.Spreadsheet.dll

Syntax:

public class Match : FunctionWithArguments

Inheritance: objectFunctionBaseFunctionWithArgumentsMatch

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

Constructors

Match()

Initializes a new MATCH function instance.

public Match()

Fields

FunctionName

string

The name of the function.

public static readonly string FunctionName

Properties

FunctionInfo

Gets the metadata describing the MATCH function's category, description, and argument requirements.

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 name of the function as "MATCH".

public override string Name { get; }

Property Value:

The name as String.

Overrides: FunctionBase.Name

Methods

EvaluateOverride(FunctionEvaluationContext<object>)

Evaluates the MATCH function by searching the lookup array for the specified value and returning its 1-based position.

protected override RadExpression EvaluateOverride(FunctionEvaluationContext<object> context)

Parameters:contextFunctionEvaluationContext<object>

The context.

Returns:

RadExpression

Function result as RadExpression.

Overrides: FunctionWithArguments.EvaluateOverride(FunctionEvaluationContext<object>)