public final class Indirect extends java.lang.Object implements FreeRefFunction
INDIRECT() returns the cell or area reference denoted by the text argument.
Syntax:
INDIRECT(ref_text,isA1Style)
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 | Field and Description |
---|---|
static FreeRefFunction |
instance |
Modifier and Type | Method and Description |
---|---|
ValueEval |
evaluate(ValueEval[] args, OperationEvaluationContext ec) |
public static final FreeRefFunction instance
public ValueEval evaluate(ValueEval[] args, OperationEvaluationContext ec)
evaluate
in interface
FreeRefFunction
(在接口 FreeRefFunction 中求值)
args
- the pre-evaluated arguments for this function. args is never
null
, nor are any of its elements.
(args - 此函数的预评估参数。 args 永远不会为空,它的任何元素也不会。)
ec
- primarily used to identify the source cell containing the formula being evaluated. may also be used to dynamically create reference evals.
(ec - 主要用于识别包含正在评估的公式的源单元格。也可用于动态创建参考评估。)
null
. Possibly an instance of
ErrorEval in the case of a specified Excel error (Exceptions are never thrown to represent Excel errors).
(从不为空。在指定 Excel 错误的情况下可能是 ErrorEval 的一个实例(从不抛出异常来表示 Excel 错误)。)
Copyright 2021 The Apache Software Foundation or its licensors, as applicable.