org.apache.poi.ss.formula

## Interface EvaluationSheet

-     @Internal
      public interface EvaluationSheet

  Abstracts a sheet for the purpose of formula evaluation.
  For POI internal use only
  Author:
    Josh Micich

- - ### Method Summary

    All Methods Instance Methods Abstract Methods
    Modifier and Type | Method and Description
    --- | ---
    `void` | `clearAllCachedResultValues()` Propagated from `EvaluationWorkbook.clearAllCachedResultValues()` to clear locally cached data.
    `EvaluationCell` | `getCell(int rowIndex, int columnIndex)`
    `int` | `getLastRowNum()`
    `boolean` | `isRowHidden(int rowIndex)` Used by SUBTOTAL and similar functions that have options to ignore hidden rows

- - ### Method Detail

    - #### getCell

          EvaluationCell getCell(int rowIndex,
                                 int columnIndex)

      Returns:
        `null` if there is no cell at the specified coordinates

    - #### 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
      Parameters:
        `rowIndex` -
      Returns:
        true if the row is hidden, false if not
      Since:
        POI 4.1.0

Copyright 2020 The Apache Software Foundation or its licensors, as applicable.