Package io.keikai.model.impl.sys.formula

Class EvalSheet

java.lang.Object

io.keikai.model.impl.sys.formula.EvalSheet

All Implemented Interfaces:

Serializable, EvaluationSheet

public class EvalSheet
extends Object
implements EvaluationSheet, Serializable

Since:

3.5.0

Author:

Pao

See Also:

Serialized Form

Constructor Summary

Constructors

Constructor	Description
EvalSheet(SSheet sheet)

Method Summary

Modifier and Type	Method	Description
void	clearAllCachedResultValues()	Propagated from EvaluationWorkbook.clearAllCachedResultValues() to clear locally cached data.
boolean	equals(Object obj)
EvaluationCell	getCell(int rowIndex, int columnIndex)
int	getLastRowNum()
SSheet	getNSheet()
int	hashCode()
boolean	isFiltered()
boolean	isHidden(int rowIndex, int columnIndex)
boolean	isRowHidden(int rowIndex)	Used by SUBTOTAL and similar functions that have options to ignore hidden rows
Iterator<EvaluationCell>	nonEmptyCellsIterator(int columnIndex)
Iterator<EvaluationCell>	nonEmptyCellsIterator(int rowStart, int rowEnd, int columnStart, int columnEnd)

Methods inherited from class java.lang.Object

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

Constructor Detail

EvalSheet

public EvalSheet(SSheet sheet)

Method Detail

getNSheet

public SSheet getNSheet()

getCell

public EvaluationCell getCell(int rowIndex,
                              int columnIndex)

Specified by:

getCell in interface EvaluationSheet

Returns:

null if there is no cell at the specified coordinates

nonEmptyCellsIterator

public Iterator<EvaluationCell> nonEmptyCellsIterator(int rowStart,
                                                      int rowEnd,
                                                      int columnStart,
                                                      int columnEnd)

Specified by:

nonEmptyCellsIterator in interface EvaluationSheet

nonEmptyCellsIterator

public Iterator<EvaluationCell> nonEmptyCellsIterator(int columnIndex)

Specified by:

nonEmptyCellsIterator in interface EvaluationSheet

clearAllCachedResultValues

public void clearAllCachedResultValues()

Description copied from interface: EvaluationSheet

Propagated from EvaluationWorkbook.clearAllCachedResultValues() to clear locally cached data.

Specified by:

clearAllCachedResultValues in interface EvaluationSheet

See Also:

WorkbookEvaluator.clearAllCachedResultValues(), EvaluationWorkbook.clearAllCachedResultValues()

getLastRowNum

public int getLastRowNum()

Specified by:

getLastRowNum in interface EvaluationSheet

Returns:

last row index referenced on this sheet, for evaluation optimization

hashCode

public int hashCode()

Overrides:

hashCode in class Object

equals

public boolean equals(Object obj)

Overrides:

equals in class Object

isHidden

public boolean isHidden(int rowIndex,
                        int columnIndex)

Specified by:

isHidden in interface EvaluationSheet

isRowHidden

public boolean isRowHidden(int rowIndex)

Description copied from interface: EvaluationSheet

Used by SUBTOTAL and similar functions that have options to ignore hidden rows

Specified by:

isRowHidden in interface EvaluationSheet

Returns:

true if the row is hidden, false if not

isFiltered

public boolean isFiltered()

Specified by:

isFiltered in interface EvaluationSheet