Filter Data

Filter is a useful feature, when you want to focus on data..

	public boolean isAutoFilterEnabled();
	
	public Range findAutoFilterRange();
	
	
	public void enableAutoFilter(boolean enable);
	

	public void applyAutoFilter();
	
	public void resetAutoFilter();

applyAutoFilter doesn't work

File:Zss-essentials-filter.png

SheetOperationUtil.toggleAutoFilter(range);

SheetOperationUtil.resetAutoFilter(range);

SheetOperationUtil.applyAutoFilter(range);

Filter command calls it.

	public void enableAutoFilter(int field, AutoFilterOperation filterOp, Object criteria1, Object criteria2, Boolean visibleDropDown);