EvaluationSheet (Keikai Spreadsheet Build 6.1.0.1 API)

All Known Implementing Classes:

EvalSheet
```
@Internal
public interface EvaluationSheet
```
Abstracts a sheet for the purpose of formula evaluation.

Method Summary

All Methods Instance Methods Abstract Methods Default Methods
Modifier and Type	Method	Description
`void`	`clearAllCachedResultValues()`	Propagated from `EvaluationWorkbook.clearAllCachedResultValues()` to clear locally cached data.
`EvaluationCell`	`getCell(int rowIndex, int columnIndex)`
`int`	`getLastRowNum()`
`default 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)`

- Method Detail
  - getCell
```
EvaluationCell getCell(int rowIndex,
                       int columnIndex)
```
    Returns:
    
    null if there is no cell at the specified coordinates
  - nonEmptyCellsIterator
```
Iterator<EvaluationCell> nonEmptyCellsIterator(int rowStart,
                                               int rowEnd,
                                               int columnStart,
                                               int columnEnd)
```
  - nonEmptyCellsIterator
```
Iterator<EvaluationCell> nonEmptyCellsIterator(int columnIndex)
```
  - clearAllCachedResultValues
```
void clearAllCachedResultValues()
```
    Propagated from EvaluationWorkbook.clearAllCachedResultValues() to clear locally cached data.
    
    Since:
    
    POI 3.15 beta 3
    
    See Also:
    
    WorkbookEvaluator.clearAllCachedResultValues(), EvaluationWorkbook.clearAllCachedResultValues()
  - getLastRowNum
```
int getLastRowNum()
```
    Returns:
    
    last row index referenced on this sheet, for evaluation optimization
    
    Since:
    
    POI 4.0.0
  - isRowHidden
```
boolean isRowHidden(int rowIndex)
```
    Used by SUBTOTAL and similar functions that have options to ignore hidden rows
    
    Returns:
    
    true if the row is hidden, false if not
    
    Since:
    
    POI 4.1.0
  - isHidden
```
boolean isHidden(int rowIndex,
                 int columnIndex)
```
  - isFiltered
```
default boolean isFiltered()
```