com.vaadin.addon.spreadsheet

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

Modifier and Type

Method and 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