Spread Windows Forms 11.0 Product Documentation
FilterBarHeaderVerticalGridLine Property
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class : FilterBarHeaderVerticalGridLine Property
Gets or sets the vertical grid line for the filter bar.
Syntax
'Declaration
 
Public Property FilterBarHeaderVerticalGridLine As GridLine
'Usage
 
Dim instance As SheetView
Dim value As GridLine
 
instance.FilterBarHeaderVerticalGridLine = value
 
value = instance.FilterBarHeaderVerticalGridLine
public GridLine FilterBarHeaderVerticalGridLine {get; set;}
Exceptions
ExceptionDescription
No value is specified (specified value is null)
Example
This example sets the FilterBarHeaderVerticalGridLine property.
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;
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
See Also

Reference

SheetView Class
SheetView Members