AutoFilterMode Enumeration

Specifies settings for the automatic filter.

Syntax

Visual Basic
C#

'Declaration
 
Public Enum AutoFilterMode 
   Inherits System.Enum

'Usage
 
Dim instance As AutoFilterMode

public enum AutoFilterMode : System.Enum

Members

Member	Description
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

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;

VB.NET

'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

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

FarPoint.Win.Spread Namespace