Package org.apache.poi.ss.formula

Interface EvaluationSheet

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

  • Method Details

    • 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:
      3.15 beta 3
      See Also:

    • getLastRowNum

      int getLastRowNum()
      Returns:
      last row index referenced on this sheet, for evaluation optimization
      Since:
      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:
      4.1.0

    • notifyDeleteCell

      default void notifyDeleteCell(int rowIndex, int columnIndex)
      Propagated from WorkbookEvaluator.notifyDeleteCell(EvaluationCell) so that an implementation which caches EvaluationCell wrappers can drop the one for the deleted cell. The default implementation does nothing.
      Parameters:
      rowIndex - zero-based row of the deleted cell
      columnIndex - zero-based column of the deleted cell
      Since:
      6.0.0

    • notifyUpdateCell

      default void notifyUpdateCell(int rowIndex, int columnIndex)
      Propagated from WorkbookEvaluator.notifyUpdateCell(EvaluationCell) so that an implementation which caches anything derived from a cell (such as its parsed formula tokens) can drop what it holds for the changed cell. The default implementation does nothing.
      Parameters:
      rowIndex - zero-based row of the changed cell
      columnIndex - zero-based column of the changed cell
      Since:
      6.0.0