Listen to Cell Changes and Action
Users can write cell change event listeners for those cases when cells' values or styles are changed.
Purpose
Implement cell change event listeners for any cell contents changes.
Cell Change Event
There are one cell change event.
- onCellChange - This event is fired whenever a cell's value or style has changed. Event listeners are provided with
org.zkoss.zss.ui.event.CellEvent
in the event listener.
Registering Cell Events
Cell change event can be registered to ZK Spreadsheet either by calling AbstractComponent.addEventListener(String, EventListener) or by using ZK MVC way i.e. using naming convention of <event-name>$<component-id>. Here is an example shown using first way
...
ss.addEventListener(org.zkoss.zss.ui.event.Events.ON_CELL_CHANGE,
new EventListener() {
public void onEvent(Event event) throws Exception {
doCellChangeEvent((CellEvent) event);
}
});
...
Note: All ZK Spreadsheet supported events have a corresponding static constants declared in org.zkoss.zss.ui.event.Events
class. For example for onCellChange event there is org.zkoss.zss.ui.event.Events.ON_CELL_CHANGE
.
Here is an example shown using second way
...
public void onCellChange$ss(CellEvent event) {
doCellChangeEvent(Ranges.range(event.getSheet(), event.getRow(), event.getColumn()));
}
...
Version History
Version | Date | Content |
---|---|---|
All source code listed in this book is at Github.