Class Indirect

  • All Implemented Interfaces:

    public final class Indirect
    extends java.lang.Object
    implements FreeRefFunction
    Implementation for Excel function INDIRECT

    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.

    • Method Detail

      • evaluate

        public ValueEval evaluate​(ValueEval[] args,
                                  OperationEvaluationContext ec)
        Specified by:
        evaluate in interface FreeRefFunction
        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.
        never null. Possibly an instance of ErrorEval in the case of a specified Excel error (Exceptions are never thrown to represent Excel errors).