Top Description Methods
org.apache.poi.ss.formula

public Interface EvaluationSheet

Known Direct Implementers
org.apache.poi.ss.formula.eval.forked.ForkedEvaluationSheet, org.apache.poi.hssf.usermodel.HSSFEvaluationSheet
Annotations
@Internal
Imports
org.apache.poi.util.Internal
Abstracts a sheet for the purpose of formula evaluation.

Method Summary

Modifier and TypeMethod and Description
public void
clearAllCachedResultValues()

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

public EvaluationCell

Returns:

null if there is no cell at the specified coordinates
getCell(int rowIndex, int columnIndex)

public int

Returns:

last row index referenced on this sheet, for evaluation optimization
getLastRowNum()

public boolean

Returns:

true if the row is hidden, false if not
isRowHidden(int rowIndex)

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

Method Detail

clearAllCachedResultValuesback to summary
public void clearAllCachedResultValues()

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

Since
POI 3.15 beta 3
See Also
WorkbookEvaluator#clearAllCachedResultValues(), EvaluationWorkbook#clearAllCachedResultValues()
getCellback to summary
public EvaluationCell getCell(int rowIndex, int columnIndex)
Returns:EvaluationCell

null if there is no cell at the specified coordinates

getLastRowNumback to summary
public int getLastRowNum()
Returns:int

last row index referenced on this sheet, for evaluation optimization

Since
POI 4.0.0
isRowHiddenback to summary
public boolean isRowHidden(int rowIndex)

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

Returns:boolean

true if the row is hidden, false if not

Since
POI 4.1.0