Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / AutoFilterColumn Method
Example


In This Topic
    AutoFilterColumn Method
    In This Topic
    Automatically filters the rows in the specified column according to the specified filter.
    Overload List
    OverloadDescription
    Automatically filters the rows in the specified column according to the specified filter.  
    Remarks
    The third parameter, filterItemIndex, checks whether the index is 0 or not; it checks whether the "All" item is selected (which is always the first item in the list and so always has index of 0) or not. This uses an index (integer) as opposed to a boolean because it is exposed as a public method and the column may or may not be selected. If the filter is a single item (or none), then the string in the second parameter, filterString, is enough information. The filterString parameter should be an exact match for one of the strings returned by the GetDropDownFilterItems method for the column.
    Example
    This example filters the second column.
    fpSpread1.ActiveSheet.Columns[2].AllowAutoFilter = true;
    fpSpread1.ActiveSheet.AutoFilterColumn(2, "London", 1); 
    
    
    FpSpread1.ActiveSheet.Columns(2).AllowAutoFilter = True
    FpSpread1.ActiveSheet.AutoFilterColumn(2, "London", 1) 
    
    See Also