Protect Worksheet or Workbook Elements"
From Documentation
(Created page with "{{ZKSpreadsheetEssentialsPageHeader}} __TOC__ ===Purpose=== ZK Spreadsheet allow user to apply protection to worksheet or cells, to prevent a user modify important data. ===ZU...") |
|||
| Line 7: | Line 7: | ||
===ZUML=== | ===ZUML=== | ||
| − | + | <source lang="xml" high="4,10"> | |
| + | <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> | ||
| + | </source> | ||
===Composer=== | ===Composer=== | ||
| Line 19: | Line 34: | ||
| 2.1.0 | | 2.1.0 | ||
| May, 2011 | | May, 2011 | ||
| − | | Protect sheet | + | | Protect sheet and lock cell |
|- | |- | ||
| | | | ||
Revision as of 04:14, 23 May 2011
Purpose
ZK Spreadsheet allow user to apply protection to worksheet or cells, to prevent a 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.