Interface Spreadsheet.CellValueHandler

  • All Superinterfaces:
    Serializable
    Enclosing class:
    Spreadsheet

    public static interface Spreadsheet.CellValueHandler
    extends Serializable
    An interface for handling the edited cell value from user input.
    • Method Summary

      All Methods Instance Methods Abstract Methods 
      Modifier and Type Method Description
      boolean cellValueUpdated​(org.apache.poi.ss.usermodel.Cell cell, org.apache.poi.ss.usermodel.Sheet sheet, int colIndex, int rowIndex, String newValue, org.apache.poi.ss.usermodel.FormulaEvaluator formulaEvaluator, org.apache.poi.ss.usermodel.DataFormatter formatter, org.apache.poi.ss.formula.ConditionalFormattingEvaluator conditionalFormattingEvaluator)
      Called if a cell value has been edited by the user by using the default cell editor.
    • Method Detail

      • cellValueUpdated

        boolean cellValueUpdated​(org.apache.poi.ss.usermodel.Cell cell,
                                 org.apache.poi.ss.usermodel.Sheet sheet,
                                 int colIndex,
                                 int rowIndex,
                                 String newValue,
                                 org.apache.poi.ss.usermodel.FormulaEvaluator formulaEvaluator,
                                 org.apache.poi.ss.usermodel.DataFormatter formatter,
                                 org.apache.poi.ss.formula.ConditionalFormattingEvaluator conditionalFormattingEvaluator)
        Called if a cell value has been edited by the user by using the default cell editor. Use Spreadsheet.setCellValueHandler(CellValueHandler) to enable it for the spreadsheet.
        Parameters:
        cell - The cell that has been edited, may be null if the cell doesn't yet exists
        sheet - The sheet the cell belongs to, the currently active sheet
        colIndex - Cell column index, 0-based
        rowIndex - Cell row index, 0-based
        newValue - The value user has entered
        formulaEvaluator - The FormulaEvaluator for this sheet
        formatter - The DataFormatter for this workbook
        conditionalFormattingEvaluator - The ConditionalFormattingEvaluator for this workbook
        Returns:
        true if component default parsing should still be done, false if not