Filter Data in a Range"
From Documentation
| Line 13: | Line 13: | ||
===Reapply filter=== | ===Reapply filter=== | ||
| − | If data within AutoFilter range has been added, modified or deleted. Reapply a filter can display different results using same criteria. Use | + | If data within AutoFilter range has been added, modified or deleted. Reapply a filter can display different results using same criteria. Use <javadoc directory="zss" method="applyFilter()">org.zkoss.zss.model.Range</javadoc> to reapply current filter. |
===Clear filter=== | ===Clear filter=== | ||
Revision as of 08:32, 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
ZUML
Composer
Version History
| Version | Date | Content |
|---|---|---|
| 2.1.0 | May, 2011 | AutoFilter |
All source code listed in this book is at Github.