Spread Windows Forms 7.0 Product Documentation
AutoFilterMode Property
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class : AutoFilterMode Property

Glossary Item Box

Gets or sets the AutoFilterMode.


Visual Basic (Declaration) 
Public Property AutoFilterMode As AutoFilterMode
Visual Basic (Usage)Copy Code
Dim instance As SheetView
Dim value As AutoFilterMode
instance.AutoFilterMode = value
value = instance.AutoFilterMode
public AutoFilterMode AutoFilterMode {get; set;}


This example uses the AutoFilterMode property.
C#Copy Code
//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.NETCopy Code
'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


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

See Also

© 2002-2014 ComponentOne, a division of GrapeCity. All Rights Reserved.