Filter Event"
From Documentation
| Line 9: | Line 9: | ||
===Filter Event=== | ===Filter Event=== | ||
| − | The <javadoc directory="zss" directory="zss">org.zkoss.zss.ui.event.FilterMouseEvent</javadoc>event is fired when user click cell filter button. | + | The <javadoc directory="zss" directory="zss">org.zkoss.zss.ui.event.FilterMouseEvent</javadoc> event is fired when user click cell filter button. |
| + | |||
| + | ===AutoFilter=== | ||
| + | The <javadoc directory="zss" directory="zss">org.zkoss.poi.ss.usermodel.AutoFilter</javadoc> represents auto filter for specified worksheet. Use AutoFilter.getRangeAddress to get auto filter range. | ||
===ZUML=== | ===ZUML=== | ||
Revision as of 11:39, 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.
Filter Event
The FilterMouseEvent event is fired when user click cell filter button.
AutoFilter
The AutoFilter represents auto filter for specified worksheet. Use AutoFilter.getRangeAddress to get auto filter range.
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.