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

Last Update : 2011/05/20


Version Date Content
2.1.0 May, 2011 AutoFilter
     


All source code listed in this book is at Github.


Last Update : 2011/05/20

Copyright © Potix Corporation. This article is licensed under GNU Free Documentation License.