GrapeCity.Spreadsheet.IAutoFilter

IAutoFilter Interface

Represents the filter for the specified worksheet.

public interface IAutoFilter

Public Interface IAutoFilter

Name	Description
AutoUpdate	Gets or sets a value indicating whether the filter update automatically after user input new value.
FilterMode	Gets a value indicating whether the worksheet is in the AutoFilter filter mode.
Filters	Gets an IFilters collection that represents all the filters in an auto filtered range.
Range	Gets an IRange object that represents the range to which the specified AutoFilter applies.
Sort	Gets the sort column or columns, and sort order for the IAutoFilter collection.

Name	Description
ApplyFilter()	Applies the specified IAutoFilter object.
GetFilteredOutRows(int)	Gets the array of rows that are filtered out.
ShowAllData(bool)	Displays all the data returned by the IAutoFilter object.