|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |
java.lang.Objectorg.apache.poi.hssf.record.formula.functions.Offset
public final class Offset
Implementation for Excel function OFFSET()
OFFSET returns an area reference that is a specified number of rows and columns from a reference cell or area. Syntax:
Constructor Summary | |
---|---|
Offset()
|
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 |
---|
public Offset()
Method Detail |
---|
public ValueEval evaluate(Eval[] args, int srcCellRow, short srcCellCol, HSSFWorkbook workbook, HSSFSheet sheet)
evaluate
in interface FreeRefFunction
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 formulasrcCellCol
- zero based column index of the cell containing the currently evaluating formulaworkbook
- is the workbook containing the formula/cell being evaluatedsheet
- is the sheet containing the formula/cell being evaluated
null
. Possibly an instance of ErrorEval in the case of
a specified Excel error (Exceptions are never thrown to represent Excel errors).
|
||||||||||
PREV CLASS NEXT CLASS | FRAMES NO FRAMES | |||||||||
SUMMARY: NESTED | FIELD | CONSTR | METHOD | DETAIL: FIELD | CONSTR | METHOD |