public final class Indirect extends java.lang.Object implements FreeRefFunction
INDIRECT() returns the cell or area reference denoted by the text argument.
ref_text a string representation of the desired reference as it would
normally be written in a cell formula.
isA1Style (default TRUE) specifies whether the ref_text should be interpreted as A1-style or R1C1-style.
|Modifier and Type||Method and Description|
public static final FreeRefFunction instance
public ValueEval evaluate(ValueEval args, OperationEvaluationContext ec)
args- the pre-evaluated arguments for this function. args is never
null, nor are any of its elements.
ec- primarily used to identify the source cell containing the formula being evaluated. may also be used to dynamically create reference evals.
null. Possibly an instance of ErrorEval in the case of a specified Excel error (Exceptions are never thrown to represent Excel errors).
Copyright 2020 The Apache Software Foundation or its licensors, as applicable.