Filter Data in a Range"

From Documentation
Line 10: Line 10:
  
 
===AutoFilter===
 
===AutoFilter===
 +
Use <javadoc directory="zss" method="autoFilter()">org.zkoss.zss.model.Range</javadoc> can toggle AutoFilter for sheet in a range. After applied AutoFilter, user can specify criteria use <javadoc directory="zss" method="autoFilter(java.lang.integer, java.lang.object, java.lang.integer, java.lang.object, java.lang.boolean)">org.zkoss.zss.model.Range</javadoc> to filter data in a range.
  
 
===Reapply filter===
 
===Reapply filter===
Line 26: Line 27:
 
| 2.1.0
 
| 2.1.0
 
| May, 2011
 
| May, 2011
−
| Filter
+
| AutoFilter
 
|-
 
|-
 
| &nbsp;
 
| &nbsp;

Revision as of 08:25, 20 May 2011


DocumentationZK Spreadsheet EssentialsWorking with ZK SpreadsheetConfigure and Control ZK SpreadsheetFilter Data in a Range
Filter Data in a Range



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

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.


Retrieved from "https://www.zkoss.org/_w/index.php?title=ZK_Spreadsheet_Essentials/Working_with_ZK_Spreadsheet/Configure_and_Control_ZK_Spreadsheet/Filter_Data_in_a_Range&oldid=18665"