Filter Data in a Range"
From Documentation
| Line 16: | Line 16: | ||
===Clear filter=== | ===Clear filter=== | ||
| + | Use <javadoc directory="zss" method="showAllData()">org.zkoss.zss.model.Range</javadoc> to clear current filter | ||
===ZUML=== | ===ZUML=== | ||
Revision as of 08:34, 20 May 2011
Available in ZK Spreadsheet EE only
ZK Spreadsheet can filter data to find a subset of data in a range.
Purpose
Filtered data display rows that meet criteria, and hide trivial data.
AutoFilter
Use Range.autoFilter() can toggle AutoFilter for sheet in a range. After applied AutoFilter, user can specify criteria use Range.autoFilter(integer, object, integer, object, boolean) to filter data in a range.
Reapply filter
If data within AutoFilter range has been added, modified or deleted. Reapply a filter can display different results using same criteria. Use Range.applyFilter() to reapply current filter.
Clear filter
Use Range.showAllData() to clear current filter
ZUML
Composer
Version History
| Version | Date | Content |
|---|---|---|
| 2.1.0 | May, 2011 | AutoFilter |
All source code listed in this book is at Github.