Filter Data in a Range

From Documentation
Revision as of 08:32, 20 May 2011 by Samchuang (talk | contribs)


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

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.