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

Implements the INDIRECT function, which evaluates a text string as a cell reference and returns the reference to that cell or range.

Definition

Constructors

Initializes a new INDIRECT function instance.

C#
public Indirect()

Fields

The name of the function.

C#
public static readonly string FunctionName

Properties

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

C#
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.

C#
public override bool LiftsOverArrays { get; }

Overrides: FunctionBase.LiftsOverArrays

Gets the name of the function as "INDIRECT".

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

The name as String.

Overrides: FunctionBase.Name

Methods

Evaluates the INDIRECT function by parsing the text reference and returning a cell reference expression or error if invalid or circular.

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

The context.

Returns:

RadExpression

Functions result as RadExpression.

Overrides: FunctionWithArguments.EvaluateOverride(FunctionEvaluationContext<object>)

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.

C#
public override bool IsSpillingArgument(int argumentIndex, RadExpression argument)
Parameters:argumentIndexintargumentRadExpressionReturns:

bool

Overrides: FunctionBase.IsSpillingArgument(int, RadExpression)