Apache POI - Common 5.3.0 · org.apache.poi.ss.formula.functions.Indirect

Modifier and Type	Field and Description
public static final FreeRefFunction	instance
private static final Logger	LOGGER

Access	Constructor and Description
private	Indirect()

Method Summary

Modifier and Type	Method and Description
private static boolean	canTrim(CharSequence text)
public ValueEval	evaluate(ValueEval[] the pre-evaluated arguments for this function. args is never `null`, nor are any of its elements. args, OperationEvaluationContext primarily used to identify the source cell containing the formula being evaluated. may also be used to dynamically create reference evals. ec) Implements org.apache.poi.ss.formula.functions.FreeRefFunction.evaluate.
private static boolean	evaluateBooleanArg(ValueEval arg, OperationEvaluationContext ec)
private static ValueEval	evaluateIndirect(final OperationEvaluationContext ec, String text, boolean isA1style)
private static String[]	Returns: array of length 2: {workbookName, sheetName,}. Second element will always be present. First element may be null if sheetName is unqualified. Returns `null` if text cannot be parsed. parseWorkbookAndSheetName(CharSequence text)
private static String	Returns: `null` if there is a syntax error in any escape sequence (the typical syntax error is a single quote character not followed by another). unescapeString(CharSequence text)

Inherited from java.lang.Object:: clone equals finalize getClass hashCode notify notifyAll toString wait wait wait

instance	back to summary
public static final FreeRefFunction instance

LOGGER	back to summary
private static final Logger LOGGER

Indirect	back to summary
private Indirect()

canTrim	back to summary
private static boolean canTrim(CharSequence text)

evaluate back to summary

evaluate	back to summary
public ValueEval evaluate(ValueEval[] args, OperationEvaluationContext ec) Implements org.apache.poi.ss.formula.functions.FreeRefFunction.evaluate. Parameters args:ValueEval[] Doc from org.apache.poi.ss.formula.functions.FreeRefFunction.evaluate. the pre-evaluated arguments for this function. args is never `null`, nor are any of its elements. ec:OperationEvaluationContext Doc from org.apache.poi.ss.formula.functions.FreeRefFunction.evaluate. primarily used to identify the source cell containing the formula being evaluated. may also be used to dynamically create reference evals. Returns:ValueEval Doc from org.apache.poi.ss.formula.functions.FreeRefFunction.evaluate. never `null`. Possibly an instance of `ErrorEval` in the case of a specified Excel error (Exceptions are never thrown to represent Excel errors). Annotations @Override

Parameters

args:ValueEval[]

the pre-evaluated arguments for this function. args is never null, nor are any of its elements.

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).

Annotations

evaluateBooleanArg	back to summary
private static boolean evaluateBooleanArg(ValueEval arg, OperationEvaluationContext ec) throws EvaluationException

evaluateIndirect	back to summary
private static ValueEval evaluateIndirect(final OperationEvaluationContext ec, String text, boolean isA1style)

parseWorkbookAndSheetName	back to summary
private static String[] parseWorkbookAndSheetName(CharSequence text) Returns:String[] array of length 2: {workbookName, sheetName,}. Second element will always be present. First element may be null if sheetName is unqualified. Returns `null` if text cannot be parsed.

unescapeString	back to summary
private static String unescapeString(CharSequence text) Returns:String `null` if there is a syntax error in any escape sequence (the typical syntax error is a single quote character not followed by another).