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.

Syntax

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
C# 
public AutoFilterMode AutoFilterMode {get; set;}

Example

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

Requirements

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.