org.zkoss.poi.ss.formula

Class SheetRefEvaluator

java.lang.Object

org.zkoss.poi.ss.formula.SheetRefEvaluator

public final class SheetRefEvaluator
extends Object

Author:

Josh Micich, Henri Chen (henrichen at zkoss dot org) - Sheet1:Sheet3!xxx 3d reference

Constructor Summary

Constructors

Constructor and Description
SheetRefEvaluator(WorkbookEvaluator bookEvaluator, org.zkoss.poi.ss.formula.EvaluationTracker tracker, int sheetIndex, int lastSheetIndex)

Method Summary

Modifier and Type	Method and Description
String	getBookName()
ValueEval	getEvalForCell(int rowIndex, int columnIndex)
ValueEval	getEvalForNonEmptyCells(int rowStart, int rowEnd, int columnStart, int columnEnd)
int	getLastSheetIndex()
String	getLastSheetName()
int	getSheetCount()
int	getSheetIndex()
String	getSheetName()
SortedValues	getSortedColumnValue(int columnIndex)
boolean	isFiltered()
boolean	isHidden(int sheetIdx, int rowIndex, int columnIndex)
boolean	isRowHidden(int rowIndex)
boolean	isSubTotal(int rowIndex, int columnIndex)

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

SheetRefEvaluator

public SheetRefEvaluator(WorkbookEvaluator bookEvaluator,
                         org.zkoss.poi.ss.formula.EvaluationTracker tracker,
                         int sheetIndex,
                         int lastSheetIndex)

Method Detail

getSheetName

public String getSheetName()

getLastSheetName

public String getLastSheetName()

getEvalForCell

public ValueEval getEvalForCell(int rowIndex,
                                int columnIndex)

getEvalForNonEmptyCells

public ValueEval getEvalForNonEmptyCells(int rowStart,
                                         int rowEnd,
                                         int columnStart,
                                         int columnEnd)

getSortedColumnValue

public SortedValues getSortedColumnValue(int columnIndex)

getBookName

public String getBookName()

isSubTotal

public boolean isSubTotal(int rowIndex,
                          int columnIndex)

Returns:

whether cell at rowIndex and columnIndex is a subtotal

See Also:

Subtotal

getSheetCount

public int getSheetCount()

getSheetIndex

public int getSheetIndex()

getLastSheetIndex

public int getLastSheetIndex()

isHidden

public boolean isHidden(int sheetIdx,
                        int rowIndex,
                        int columnIndex)

isRowHidden

public boolean isRowHidden(int rowIndex)

isFiltered

public boolean isFiltered()