Package org.apache.poi.ss.formula

Interface TwoDEval

    • Method Detail

      • getValue

        ValueEval getValue​(int rowIndex,
                   int columnIndex)
        Parameters:
        rowIndex - relative row index (zero based)
        columnIndex - relative column index (zero based)
        Returns:
        element at the specified row and column position

      • getWidth

        int getWidth()

      • getHeight

        int getHeight()

      • isRow

        default boolean isRow()
        Returns:
        true if the area has just a single row, this also includes the trivial case when the area has just a single cell.

      • isColumn

        boolean isColumn()
        Returns:
        true if the area has just a single column, this also includes the trivial case when the area has just a single cell.

      • getRow

        TwoDEval getRow​(int rowIndex)
        Parameters:
        rowIndex - relative row index (zero based)
        Returns:
        a single row TwoDEval

      • getColumn

        TwoDEval getColumn​(int columnIndex)
        Parameters:
        columnIndex - relative column index (zero based)
        Returns:
        a single column TwoDEval

      • isSubTotal

        boolean isSubTotal​(int rowIndex,
                   int columnIndex)
        Returns:
        true if the cell at row and col is a subtotal

      • isHidden

        boolean isHidden​(int rowIndex,
                 int columnIndex)
        Returns:
        true if the cell at row and col is hidden
        Since:
        3.9.7

      • isRowHidden

        boolean isRowHidden​(int rowIndex)
        Returns:
        true if the row is hidden
        See Also:
        Subtotal

      • isFiltered

        default boolean isFiltered()
        Returns:
        true if the sheet of the area exists any auto filter or table filter which is applied.
        See Also:
        Subtotal