Class
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

Constructors

Index()

Initializes a new INDEX function instance.

Declaration

cs-api-definition
public Index()

Fields

FunctionName

The name of the function.

Declaration

cs-api-definition
public static readonly string FunctionName

Field Value

string

Properties

ArgumentConversionRules

Gets the rules that define how arguments are converted during function evaluation.

Declaration

cs-api-definition
public override ArgumentConversionRules ArgumentConversionRules { get; }

Property Value

ArgumentConversionRules

The argument conversion rules as ArgumentConversionRules.

Overrides FunctionBase.ArgumentConversionRules

FunctionInfo

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

Declaration

cs-api-definition
public override FunctionInfo FunctionInfo { get; }

Property Value

FunctionInfo

The function info as FunctionInfo.

Overrides FunctionBase.FunctionInfo

Name

Gets the name of the function as "INDEX".

Declaration

cs-api-definition
public override string Name { get; }

Property Value

string

The name as String.

Overrides FunctionBase.Name

Methods

EvaluateOverride(FunctionEvaluationContext<object>)

Evaluates the INDEX function by locating and returning the cell reference or value at the specified row and column coordinates.

Declaration

cs-api-definition
protected override RadExpression EvaluateOverride(FunctionEvaluationContext<object> context)

Parameters

context

FunctionEvaluationContext<object>

The context.

Returns

RadExpression

Functions result as RadExpression.

Overrides FunctionWithArguments.EvaluateOverride(FunctionEvaluationContext<object>)