FilterBarHeaderHorizontalGridLine Property

Visual Basic
C#

'Declaration
 
Public Property FilterBarHeaderHorizontalGridLine As GridLine

'Usage
 
Dim instance As SheetView
Dim value As GridLine
 
instance.FilterBarHeaderHorizontalGridLine = value
 
value = instance.FilterBarHeaderHorizontalGridLine

public GridLine FilterBarHeaderHorizontalGridLine {get; set;}

Exception	Description
System.ArgumentNullException	No value is specified (specified value is null)

This example sets the FilterBarHeaderHorizontalGridLine property.

C#

fpSpread1.VisualStyles = FarPoint.Win.VisualStyles.Off;
FarPoint.Win.Spread.NamedStyle backstyle = new FarPoint.Win.Spread.NamedStyle("BlueBack", "FilterBarEnhanced");
backstyle.BackColor = Color.Blue;
fpSpread1.NamedStyles.Add(backstyle);

FarPoint.Win.Spread.SheetView sheetView = fpSpread1.ActiveSheet;
sheetView.AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.FilterBar;
sheetView.FilterBarHeaderVerticalGridLine = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Raised, Color.Red, Color.Green, Color.Pink, 10);
sheetView.FilterBarHeaderHorizontalGridLine = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Lowered, Color.Orange, Color.Green, Color.Pink, 10);
sheetView.FilterBarHeaderStyle = backstyle;

Visual Basic

FpSpread1.VisualStyles = FarPoint.Win.VisualStyles.Off
Dim backstyle As New FarPoint.Win.Spread.NamedStyle("BlueBack", "FilterBarEnhanced")
backstyle.BackColor = Color.Blue
FpSpread1.NamedStyles.Add(backstyle)

Dim sheetview As FarPoint.Win.Spread.SheetView = FpSpread1.ActiveSheet
sheetview.AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.FilterBar
sheetview.FilterBarHeaderVerticalGridLine = New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Raised, Color.Red, Color.Green, Color.Pink, 10)
sheetview.FilterBarHeaderHorizontalGridLine = New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Lowered, Color.Orange, Color.Green, Color.Pink, 10)
sheetview.FilterBarHeaderStyle = backstyle

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

Reference

SheetView Class
SheetView Members