LookupFunctionBase
Abstract base for table lookup functions such as VLOOKUP, HLOOKUP, and LOOKUP, providing shared logic for searching and matching values in ranges.
Definition
Namespace:Telerik.Documents.Spreadsheet.Expressions.Functions
Assembly:Telerik.Windows.Documents.Spreadsheet.dll
Syntax:
public abstract class LookupFunctionBase : FunctionWithArgumentsInheritance: objectFunctionBaseFunctionWithArgumentsLookupFunctionBase
Derived Classes:
Inherited Members
Constructors
Initializes a new lookup function base instance.
protected LookupFunctionBase()Properties
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:
Methods
Evaluates the lookup function by extracting the lookup and result vectors, applying the search criteria, and returning the matched value.
protected override RadExpression EvaluateOverride(FunctionEvaluationContext<object> context)The context.
Returns:Functions result as RadExpression.
Overrides: