Spread Windows Forms 17
GrapeCity.Spreadsheet Assembly / GrapeCity.Spreadsheet Namespace / AutoFilter Class
Properties Methods


In This Topic
    AutoFilter Class Members
    In This Topic

    The following tables list the members exposed by AutoFilter.

    Public Properties
     NameDescription
    Public PropertyContainerGets the auto filter's container.  
    Public PropertyFilterModeGets a value indicating whether the worksheet is in the AutoFilter filter mode.  
    Public PropertyItemGets the AutoFilterColumn at the specified column.  
    Public PropertyRangeGets a GrapeCity.CalcEngine.RangeReference value that represents the range to which the specified AutoFilter applies.  
    Public PropertySortGets the sort object.  
    Public PropertyWorksheetGets the worksheet which contains this IAutoFilterOwner object.  
    Top
    Public Methods
     NameDescription
    Public MethodAddFilterAdds a filter to the specified column.  
    Public MethodApplyFilterApplies the specified AutoFilter object.  
    Public MethodClearClears the filter and sort state at the specified column for the current object.  
    Public MethodClearInternal  
    Public MethodDeleteRemoves the filter from the current worksheet.  
    Public MethodHideFilterButtonHides the filter button.  
    Public MethodRemoveFilterRemoves a filter from the specified column.  
    Public MethodSetActiveFilterActivates the specified Filter for a column and re-apply filtering.  
    Public MethodShowAllDataDisplays all the data returned by the AutoFilter object.  
    Public MethodShowFilterButtonShows the filter button.  
    Top
    See Also

    Reference

    AutoFilter Class
    GrapeCity.Spreadsheet Namespace