Protect Worksheet or Workbook Elements
From Documentation
Purpose
ZK Spreadsheet allow user to apply protection to worksheet or cells, to prevent user modify important data.
ZUML
<zk>
<div height="100%" width="100%" apply="org.zkoss.zssessentials.config.ProtectionComposer">
Criteria: hide "222"
<div>
<Button id="toggleSheetProtection" label="Toggle sheet protection" mold="trendy"></Button>
<Button id="toggleLockCells" label="Toggle lock cells" mold="trendy"></Button>
</div>
<spreadsheet id="spreadsheet" src="/WEB-INF/excel/config/autoFilter.xlsx"
maxrows="200"
maxcolumns="40"
width="100%"
height="450px"></spreadsheet>
</div>
</zk>
Composer
Version History
Version | Date | Content |
---|---|---|
2.1.0 | May, 2011 | Protect sheet and lock cell |
All source code listed in this book is at Github.