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
  
 
===Clear filter===
 
===Clear filter===

Revision as of 08:31, 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

Clear 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.