org.zkoss.poi.ss.formula

Class LazyAreaEval

java.lang.Object

org.zkoss.poi.ss.formula.eval.AreaEvalBase

org.zkoss.poi.ss.formula.LazyAreaEval

All Implemented Interfaces:

AreaEval, HyperlinkEval, ValueEval, TwoDEval

public final class LazyAreaEval
extends AreaEvalBase
implements HyperlinkEval

Author:

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

Constructor Summary

Constructors

Constructor and Description
LazyAreaEval(int firstRowIndex, int firstColumnIndex, int lastRowIndex, int lastColumnIndex, boolean firstRowRel, boolean firstColRel, boolean lastRowRel, boolean lastColRel, SheetRefEvaluator evaluator)

Method Summary

Modifier and Type	Method and Description
String	getBookName()
LazyAreaEval	getColumn(int columnIndex)
int	getDepth()
Hyperlink	getHyperlink() Returns the associated hyperlink if this ValueEval is a label of the HYPERLINK function.
String	getLastSheetName()
ValueEval	getNonEmptyCellValues()
SheetRefEvaluator	getRefEvaluator()
ValueEval	getRelativeValue(int relativeRowIndex, int relativeColumnIndex)
LazyAreaEval	getRow(int rowIndex)
String	getSheetName()
boolean	isFiltered()
boolean	isHidden(int rowIndex, int columnIndex)
boolean	isRowHidden(int rowIndex)
boolean	isSubTotal(int rowIndex, int columnIndex)
AreaEval	offset(int relFirstRowIx, int relLastRowIx, int relFirstColIx, int relLastColIx) Creates an AreaEval offset by a relative amount from from the upper left cell of this area
void	setHyperlink(Hyperlink hyperlink) Sets the associated hyperlink if this ValueEval is a label of the HYPERLINK function.
String	toString()

Methods inherited from class org.zkoss.poi.ss.formula.eval.AreaEvalBase

contains, containsColumn, containsRow, getAbsoluteValue, getFirstColumn, getFirstRow, getHeight, getLastColumn, getLastRow, getValue, getWidth, isColumn, isFirstColRelative, isFirstRowRelative, isLastColRelative, isLastRowRelative, isRow

Methods inherited from class java.lang.Object

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

Constructor Detail

LazyAreaEval

public LazyAreaEval(int firstRowIndex,
                    int firstColumnIndex,
                    int lastRowIndex,
                    int lastColumnIndex,
                    boolean firstRowRel,
                    boolean firstColRel,
                    boolean lastRowRel,
                    boolean lastColRel,
                    SheetRefEvaluator evaluator)

Method Detail

getRelativeValue

public ValueEval getRelativeValue(int relativeRowIndex,
                                  int relativeColumnIndex)

Specified by:

getRelativeValue in interface AreaEval

Specified by:

getRelativeValue in class AreaEvalBase

Returns:

the ValueEval from within this area at the specified relativeRowIndex and relativeColumnIndex. Never null (possibly BlankEval). The specified indexes should relative to the top left corner of this area.

getNonEmptyCellValues

public ValueEval getNonEmptyCellValues()

Specified by:

getNonEmptyCellValues in interface TwoDEval

offset

public AreaEval offset(int relFirstRowIx,
                       int relLastRowIx,
                       int relFirstColIx,
                       int relLastColIx)

Description copied from interface: AreaEval

Creates an AreaEval offset by a relative amount from from the upper left cell of this area

Specified by:

offset in interface AreaEval

getRow

public LazyAreaEval getRow(int rowIndex)

Specified by:

getRow in interface TwoDEval

Parameters:

rowIndex - relative row index (zero based)

Returns:

a single row TwoDEval

getColumn

public LazyAreaEval getColumn(int columnIndex)

Specified by:

getColumn in interface TwoDEval

Parameters:

columnIndex - relative column index (zero based)

Returns:

a single column TwoDEval

getSheetName

public String getSheetName()

getLastSheetName

public String getLastSheetName()

getBookName

public String getBookName()

toString

public String toString()

Overrides:

toString in class Object

isSubTotal

public boolean isSubTotal(int rowIndex,
                          int columnIndex)

Specified by:

isSubTotal in interface TwoDEval

Overrides:

isSubTotal in class AreaEvalBase

Returns:

whether cell at rowIndex and columnIndex is a subtotal

setHyperlink

public void setHyperlink(Hyperlink hyperlink)

Description copied from interface: HyperlinkEval

Sets the associated hyperlink if this ValueEval is a label of the HYPERLINK function.

Specified by:

setHyperlink in interface HyperlinkEval

Parameters:

hyperlink - the associated hyperlink

getHyperlink

public Hyperlink getHyperlink()

Description copied from interface: HyperlinkEval

Returns the associated hyperlink if this ValueEval is a label of the HYPERLINK function.

Specified by:

getHyperlink in interface HyperlinkEval

Returns:

the associated hyperlink.

getDepth

public int getDepth()

Specified by:

getDepth in interface AreaEval

isHidden

public boolean isHidden(int rowIndex,
                        int columnIndex)

Specified by:

isHidden in interface TwoDEval

Returns:

true if the cell at row and col is hidden

isRowHidden

public boolean isRowHidden(int rowIndex)

Specified by:

isRowHidden in interface TwoDEval

Returns:

true if the row is hidden

See Also:

Subtotal

isFiltered

public boolean isFiltered()

Specified by:

isFiltered in interface TwoDEval

Returns:

true if the sheet of the area exists any auto filter or table filter which is applied.

See Also:

Subtotal

getRefEvaluator

public SheetRefEvaluator getRefEvaluator()

Specified by:

getRefEvaluator in interface AreaEval