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.
    Syntax
    'Declaration
     
    Public Enum AutoFilterMode 
       Inherits System.Enum
    'Usage
     
    Dim instance As AutoFilterMode
    public enum AutoFilterMode : System.Enum 
    Members
    MemberDescription
    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.
    Example
    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

    System.Object
       System.ValueType
          System.Enum
             FarPoint.Win.Spread.AutoFilterMode

    See Also