Interface RefEval

All Superinterfaces:
ValueEval
All Known Subinterfaces:
LazyRefEval

public interface RefEval extends ValueEval
Reference to a single cell — wraps the cell's value and exposes its coordinates for functions that need them (OFFSET, INDIRECT, CELL, …).

The first* / last* sheet indices match the 3-D-reference shape: a single-cell reference normally has firstSheetIndex == lastSheetIndex, but a 3-D reference (e.g. Sheet1:Sheet3!A1) returns a span.

Replaces org.apache.poi.ss.formula.eval.RefEval.

Since:
7.0.0
  • Method Details

    • getInnerValueEval

      ValueEval getInnerValueEval(int sheetIndex)
      Returns:
      the cell's evaluated value.
    • getRow

      int getRow()
      Returns:
      0-based row coordinate in the sheet.
    • getColumn

      int getColumn()
      Returns:
      0-based column coordinate in the sheet.
    • getFirstSheetIndex

      int getFirstSheetIndex()
      Returns:
      inclusive starting sheet index of the (3-D) reference.
    • getLastSheetIndex

      int getLastSheetIndex()
      Returns:
      inclusive ending sheet index of the (3-D) reference.