Index
Implements the INDEX function, which returns the cell reference or value at the intersection of a specified row and column within a range or array.
Definition
Namespace:Telerik.Documents.Spreadsheet.Expressions.Functions
Assembly:Telerik.Windows.Documents.Spreadsheet.dll
Syntax:
public class Index : FunctionWithArguments
Inheritance: objectFunctionBaseFunctionWithArgumentsIndex
Inherited Members
Constructors
Initializes a new INDEX function instance.
public Index()
Fields
The name of the function.
public static readonly string FunctionName
Properties
Gets the rules that define how arguments are converted during function evaluation.
public override ArgumentConversionRules ArgumentConversionRules { get; }
The argument conversion rules as ArgumentConversionRules.
Overrides:
Gets the metadata describing the INDEX function's category, description, and argument requirements.
public override FunctionInfo FunctionInfo { get; }
The function info as FunctionInfo.
Overrides:
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 INDEX function by locating and returning the cell reference or value at the specified row and column coordinates.
protected override RadExpression EvaluateOverride(FunctionEvaluationContext<object> context)
The context.
Returns:Functions result as RadExpression.
Overrides:
Determines whether the argument at argumentIndex can cause this function to
return a multi-element array (and therefore to spill). The default implementation combines
the argument metadata with the argument expression's array-return capability. Override when
spilling depends on the argument's runtime value.
public override bool IsSpillingArgument(int argumentIndex, RadExpression argument)
Overrides: