Filter Event"
From Documentation
(Created page with "{{ZKSpreadsheetEssentialsPageHeader}} __TOC__ {{ZSS EE}} ===Purpose=== ZK Spreadsheet can filter data to find a subset of data in a range. Filtered data display rows that meet...") |
|||
| Line 7: | Line 7: | ||
===Purpose=== | ===Purpose=== | ||
ZK Spreadsheet can filter data to find a subset of data in a range. Filtered data display rows that meet criteria, and hide trivial data. | ZK Spreadsheet can filter data to find a subset of data in a range. Filtered data display rows that meet criteria, and hide trivial data. | ||
| + | |||
| + | ===AutoFilter=== | ||
| + | |||
| + | ===ZUML=== | ||
| + | <source lang="xml"> | ||
| + | <zk> | ||
| + | <window title="ZSS Filter Events" border="normal" width="100%" | ||
| + | height="100%" apply="org.zkoss.zssessentials.events.FilterEventComposer"> | ||
| + | <hlayout> | ||
| + | <listbox id="criteriaListbox" checkmark="true" multiple="true" width="200px" height="800px"></listbox> | ||
| + | <spreadsheet id="spreadsheet" width="800px" height="800px" maxrows="200" | ||
| + | maxcolumns="20" src="/WEB-INF/excel/events/filter.xlsx"> | ||
| + | </spreadsheet> | ||
| + | </hlayout> | ||
| + | </window> | ||
| + | </zk> | ||
| + | </source> | ||
| + | ===Composer=== | ||
Revision as of 10:43, 23 May 2011
Available in ZK Spreadsheet EE only
Purpose
ZK Spreadsheet can filter data to find a subset of data in a range. Filtered data display rows that meet criteria, and hide trivial data.
AutoFilter
ZUML
<zk>
<window title="ZSS Filter Events" border="normal" width="100%"
height="100%" apply="org.zkoss.zssessentials.events.FilterEventComposer">
<hlayout>
<listbox id="criteriaListbox" checkmark="true" multiple="true" width="200px" height="800px"></listbox>
<spreadsheet id="spreadsheet" width="800px" height="800px" maxrows="200"
maxcolumns="20" src="/WEB-INF/excel/events/filter.xlsx">
</spreadsheet>
</hlayout>
</window>
</zk>
Composer
Version History
| Version | Date | Content |
|---|---|---|
| 2.1.0 | May, 2011 | AutoFilter |
All source code listed in this book is at Github.