public final class OperationEvaluationContext
extends java.lang.Object
Modifier and Type | Field and Description |
---|---|
static FreeRefFunction |
UDF |
Constructor and Description |
---|
OperationEvaluationContext(WorkbookEvaluator bookEvaluator,
EvaluationWorkbook workbook,
int sheetIndex,
int srcRowNum,
int srcColNum,
org.zkoss.poi.ss.formula.EvaluationTracker tracker,
DependencyTracker dependencyTracker,
java.lang.Object ref)
Deprecated.
|
OperationEvaluationContext(WorkbookEvaluator bookEvaluator,
EvaluationWorkbook workbook,
int sheetIndex,
int srcRowNum,
int srcColNum,
org.zkoss.poi.ss.formula.EvaluationTracker tracker,
DependencyTracker dependencyTracker,
java.lang.Object ref,
int[] offset) |
Modifier and Type | Method and Description |
---|---|
FreeRefFunction |
findUserDefinedFunction(java.lang.String functionName) |
ValueEval |
getArea3DEval(int firstRowIndex,
int firstColumnIndex,
int lastRowIndex,
int lastColumnIndex,
boolean row1Rel,
boolean col1Rel,
boolean row2Rel,
boolean col2Rel,
int extSheetIndex) |
ValueEval |
getAreaEval(int firstRowIndex,
int firstColumnIndex,
int lastRowIndex,
int lastColumnIndex,
boolean row1Rel,
boolean col1Rel,
boolean row2Rel,
boolean col2Rel) |
ValueEval |
getArrayEval(ArrayPtg ptg) |
int |
getColumnIndex() |
java.lang.Object |
getDependent() |
ValueEval |
getDynamicReference(java.lang.String workbookName,
java.lang.String sheetName,
java.lang.String lastSheetName,
java.lang.String refStrPart1,
java.lang.String refStrPart2,
boolean isA1Style)
Resolves a cell or area reference dynamically.
|
EvaluationName |
getName(java.lang.String name,
int contextSheetIndex) |
ValueEval |
getNameXEval(NameXPtg nameXPtg) |
int |
getPtgIndex() |
ValueEval |
getRef3DEval(int rowIndex,
int columnIndex,
boolean rowRel,
boolean colRel,
int extSheetIndex) |
ValueEval |
getRefEval(int rowIndex,
int columnIndex,
boolean rowRel,
boolean colRel) |
SheetRefEvaluator |
getRefEvaluatorForCurrentSheet() |
int |
getRowIndex() |
java.lang.String |
getSheetName() |
EvaluationWorkbook |
getWorkbook() |
WorkbookEvaluator |
getWorkbookEvaluator() |
void |
setPtgIndex(int index) |
public static final FreeRefFunction UDF
@Deprecated public OperationEvaluationContext(WorkbookEvaluator bookEvaluator, EvaluationWorkbook workbook, int sheetIndex, int srcRowNum, int srcColNum, org.zkoss.poi.ss.formula.EvaluationTracker tracker, DependencyTracker dependencyTracker, java.lang.Object ref)
public OperationEvaluationContext(WorkbookEvaluator bookEvaluator, EvaluationWorkbook workbook, int sheetIndex, int srcRowNum, int srcColNum, org.zkoss.poi.ss.formula.EvaluationTracker tracker, DependencyTracker dependencyTracker, java.lang.Object ref, int[] offset)
public EvaluationWorkbook getWorkbook()
public int getRowIndex()
public int getColumnIndex()
public java.lang.String getSheetName()
public SheetRefEvaluator getRefEvaluatorForCurrentSheet()
public ValueEval getDynamicReference(java.lang.String workbookName, java.lang.String sheetName, java.lang.String lastSheetName, java.lang.String refStrPart1, java.lang.String refStrPart2, boolean isA1Style)
workbookName
- the name of the workbook containing the reference. If null
the current workbook is assumed. Note - to evaluate formulas which use multiple workbooks,
a CollaboratingWorkbooksEnvironment
must be set up.sheetName
- the name of the sheet containing the reference. May be null
(when workbookName is also null) in which case the current workbook and sheet is
assumed.refStrPart1
- the single cell reference or first part of the area reference. Must not
be null
.refStrPart2
- the second part of the area reference. For single cell references this
parameter must be null
isA1Style
- specifies the format for refStrPart1 and refStrPart2.
Pass true
for 'A1' style and false
for 'R1C1' style.
TODO - currently POI only supports 'A1' reference styleRefEval
or AreaEval
public FreeRefFunction findUserDefinedFunction(java.lang.String functionName)
public ValueEval getRefEval(int rowIndex, int columnIndex, boolean rowRel, boolean colRel)
public ValueEval getRef3DEval(int rowIndex, int columnIndex, boolean rowRel, boolean colRel, int extSheetIndex)
public ValueEval getAreaEval(int firstRowIndex, int firstColumnIndex, int lastRowIndex, int lastColumnIndex, boolean row1Rel, boolean col1Rel, boolean row2Rel, boolean col2Rel)
public WorkbookEvaluator getWorkbookEvaluator()
public ValueEval getArea3DEval(int firstRowIndex, int firstColumnIndex, int lastRowIndex, int lastColumnIndex, boolean row1Rel, boolean col1Rel, boolean row2Rel, boolean col2Rel, int extSheetIndex)
public int getPtgIndex()
public void setPtgIndex(int index)
public EvaluationName getName(java.lang.String name, int contextSheetIndex)
public java.lang.Object getDependent()
Copyright © 2005-2010 Potix Corporation. All Rights Reserved.