org.apache.poi.hssf.record.formula.functions
Class Indirect

java.lang.Object
  extended by org.apache.poi.hssf.record.formula.functions.Indirect
All Implemented Interfaces:
FreeRefFunction

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.

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.

Author:
Josh Micich

Constructor Summary
Indirect()
           
 
Method Summary
 ValueEval evaluate(Eval[] args, int srcCellRow, short srcCellCol, HSSFWorkbook workbook, HSSFSheet sheet)
           
 
Methods inherited from class java.lang.Object
clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait
 

Constructor Detail

Indirect

public Indirect()
Method Detail

evaluate

public ValueEval evaluate(Eval[] args,
                          int srcCellRow,
                          short srcCellCol,
                          HSSFWorkbook workbook,
                          HSSFSheet sheet)
Specified by:
evaluate in interface FreeRefFunction
Parameters:
args - the pre-evaluated arguments for this function. args is never null, nor are any of its elements.
srcCellRow - zero based row index of the cell containing the currently evaluating formula
srcCellCol - zero based column index of the cell containing the currently evaluating formula
workbook - is the workbook containing the formula/cell being evaluated
sheet - is the sheet containing the formula/cell being evaluated
Returns:
never null. Possibly an instance of ErrorEval in the case of a specified Excel error (Exceptions are never thrown to represent Excel errors).


Copyright 2008 The Apache Software Foundation or its licensors, as applicable.