@Listen("onStartEditing = #ss")
public void onStartEditing(StartEditingEvent event) {
StringBuilder info = new StringBuilder();
String ref = Ranges.getCellRefString(event.getRow(), event.getColumn());
info.append("Start editing ")
.append(ref)
.append(", editing-value is ")
.append("\"" + event.getEditingValue() + "\"")
.append(" client-value is ")
.append("\"" + event.getClientValue() + "\"");
if (isShowEventInfo(event.getName())) {
addInfo(info.toString());
}
if (ref.equals("D1")) {
String newValue = "Surprise!!";
// we change the editing value
event.setEditingValue(newValue);
addInfo("Editing value is change to " + newValue);
} else if (ref.equals("E1")) {
// forbid editing
event.cancel();
addInfo("Editing E1 is canceled");
}
}
@Listen("onCellRightClick = #ss")
public void onCellRightClick(CellMouseEvent event) {
StringBuilder info = new StringBuilder();
info.append("Right-click on cell ")
.append(Ranges.getCellRefString(event.getRow(), event.getColumn()));
if (isShowEventInfo(event.getName())) {
addInfo(info.toString());
}
}
@Listen("onCellFocus = #ss")
public void onCellFocus(CellEvent event) {
StringBuilder info = new StringBuilder();
info.append("Focus on[")
.append(Ranges.getCellRefString(event.getRow(), event.getColumn()))
.append("]");
if (isShowEventInfo(event.getName())) {
addInfo(info.toString());
}
}
@Listen("onCellValidator = #ss")
public void onCellValidator(CellMouseEvent event) {
StringBuilder info = new StringBuilder();
info.append("Validation button clicked ")
.append(" on cell ")
.append(Ranges.getCellRefString(event.getRow(), event.getColumn()));
if (isShowEventInfo(event.getName())) {
addInfo(info.toString());
}
}
@Listen("onEditboxEditing = #ss")
public void onEditboxEditing(EditboxEditingEvent event) {
StringBuilder info = new StringBuilder();
String ref = Ranges.getCellRefString(event.getRow(), event.getColumn());
info.append("Editing ")
.append(ref)
.append(", value is ")
.append("\"" + event.getEditingValue() + "\"");
if (isShowEventInfo(event.getName())) {
addInfo(info.toString());
}
}
@Listen("onCellHyperlink = #ss")
public void onCellHyperlink(CellHyperlinkEvent event) {
StringBuilder info = new StringBuilder();
info.append("Hyperlink ")
.append(event.getType())
.append(" on : ")
.append(Ranges.getCellRefString(event.getRow(), event.getColumn()))
.append(", address : ")
.append(event.getAddress());
if (isShowEventInfo(event.getName())) {
addInfo(info.toString());
}
}
