Data Validation"
From Documentation
m |
m |
||
Line 41: | Line 41: | ||
===Composer=== | ===Composer=== | ||
+ | The composer prepare data from DataValidation, use | ||
+ | |||
<source lang="java" high="2,7,9,22 "> | <source lang="java" high="2,7,9,22 "> | ||
private DataValidation getDataValidation() { | private DataValidation getDataValidation() { |
Revision as of 00:47, 11 January 2012
Available in ZK Spreadsheet EE only
Purpose
Data validation is invaluable when a workbook share with other users in a organization, to make sure the data entered in the workbook to be accurate and consistent.
Data Validation
Validation message
Prompt
Error alert
Click cancel button will remove editing value
Click retry button allow user to continue editing cell value without empty editing value
Validation list
ZUML
<div apply="org.zkoss.zssessentials.config.ValidationComposer" width="100%" vflex="1">
<combobox id="deparmentCombobox">
</combobox>
<spreadsheet id="spreadsheet" src="/WEB-INF/excel/config/validation.xlsx"
maxrows="100" maxcolumns="20"
width="100%" vflex="1">
</spreadsheet>
</div>
Composer
The composer prepare data from DataValidation, use
private DataValidation getDataValidation() {
return sheet.getDataValidation(DATA_VALIDATION_ROW, DATA_VALIDATION_COL);
}
private void initCombobox() {
DataValidation dataValidation = getDataValidation();
DataValidationConstraint constraint = dataValidation.getValidationConstraint();
switch (constraint.getValidationType()) {
case ValidationType.LIST:
ListModelList model = new ListModelList(constraint.getExplicitListValues());
deparmentCombobox.setModel(model);
break;
}
//Add illegal item
((ListModelList) deparmentCombobox.getModel()).add("Illegal cell value");
}
public void onSelect$deparmentCombobox() {
String cellValue = deparmentCombobox.getSelectedItem().getLabel();
boolean validInput = spreadsheet.validate(sheet, DATA_VALIDATION_ROW, DATA_VALIDATION_COL, cellValue, null);
if (validInput) {
Ranges.range(sheet, DATA_VALIDATION_ROW, DATA_VALIDATION_COL).setEditText(cellValue);
}
}
Version History
Version | Date | Content |
---|---|---|
Since 2.2.0 | January, 2012 | Support Data Validation |
All source code listed in this book is at Github.