Data validation can restrict the type of data or values entered into a cell. It can also prompt users with an input message and display an alert message when users enter invalid data.

In the demo, some common data validation like date and drop-down list are presented. Warning message will pop up when the input is invalid (date & discount).

For details, please refer to Keikai Developer Reference.

<?xml version="1.0" encoding="UTF-8"?>
<zk xmlns="http://www.zkoss.org/2005/zul"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://www.zkoss.org/2005/zul http://keikai.io/2019/zul/zul.xsd">
<spreadsheet id="spreadsheet" width="100%" apply="demo.FocusComposer"
	src="/WEB-INF/books/Invoice-validation.xlsx" maxVisibleRows="19"
	maxVisibleColumns="11" vflex="1"/>
</zk>