Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / AutoFilterMode Enumeration
Example Example

In This Topic
    AutoFilterMode Enumeration
    In This Topic
    Specifies settings for the automatic filter.
    Public Enum AutoFilterMode 
       Inherits System.Enum
    Dim instance As AutoFilterMode
    public enum AutoFilterMode : System.Enum 
    EnhancedContextMenu Displays a context menu for the automatic filter
    FilterBar Displays a filter bar for the automatic filter
    FilterGadget Displays a filter gadget for the automatic filter
    RangeFilter Internal use only. The mode used to specify a range filter mode.
    This example uses the AutoFilterMode enumeration.
    //Basic Filter Bar
    FarPoint.Win.Spread.SheetView sheetView = fpSpread1.ActiveSheet;
    sheetView.AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.FilterBar;
    sheetView.FilterBar.Height = 30;
    sheetView.FilterBarHeaderStyle.Border = new FarPoint.Win.DoubleLineBorder(Color.Red);
    sheetView.FilterBarHeaderStyle.BackColor = Color.Yellow;  
    'Basic Filter Bar
    Dim sheetView As FarPoint.Win.Spread.SheetView = FpSpread1.ActiveSheet
    sheetView.AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.FilterBar
    sheetView.FilterBar.Height = 30
    sheetView.FilterBarHeaderStyle.Border = New FarPoint.Win.DoubleLineBorder(Color.Red)
    sheetView.FilterBarHeaderStyle.BackColor = Color.Yellow
    Inheritance Hierarchy


    See Also