Spread Windows Forms 11.0 Product Documentation
VerticalGridLine Property (FilterBar)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > FilterBar Class : VerticalGridLine Property
Gets or sets the GridLine object for the vertical grid line in the filter bar.
Syntax
'Declaration
 
Public Property VerticalGridLine As GridLine
'Usage
 
Dim instance As FilterBar
Dim value As GridLine
 
instance.VerticalGridLine = value
 
value = instance.VerticalGridLine
public GridLine VerticalGridLine {get; set;}
Example
This example sets the VerticalGridLine property.
FarPoint.Win.Spread.SheetView sheetView = fpSpread1.ActiveSheet;
sheetView.AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.FilterBar;
sheetView.FilterBar.Cells[0].CellType = new FarPoint.Win.Spread.CellType.FilterBarCellType();
sheetView.FilterBar.HorizontalGridLine = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.Red);
sheetView.FilterBar.VerticalGridLine = new FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.Orange);
FarPoint.Win.Spread.CellType.FilterBarCellType cellType = new FarPoint.Win.Spread.CellType.FilterBarCellType();
sheetView.FilterBar.Cells[3].CellType = cellType;
sheetView.FilterBar.Height = 30; 
fpSpread1.ActiveSheet.Cells[0, 0, 2, 5].Text = "Test";
fpSpread1.ActiveSheet.Cells[3, 0, 5, 5].Text = "A";
Dim sheetView As FarPoint.Win.Spread.SheetView = FpSpread1.ActiveSheet
sheetView.AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.FilterBar
sheetView.FilterBar.Cells(0).CellType = New FarPoint.Win.Spread.CellType.FilterBarCellType()
sheetView.FilterBar.HorizontalGridLine = New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.Red)
sheetView.FilterBar.VerticalGridLine = New FarPoint.Win.Spread.GridLine(FarPoint.Win.Spread.GridLineType.Flat, Color.Orange)
Dim cellType As New FarPoint.Win.Spread.CellType.FilterBarCellType()
sheetView.FilterBar.Cells(3).CellType = cellType
sheetView.FilterBar.Height = 30
FpSpread1.ActiveSheet.Cells(0, 0, 2, 5).Text = "Test"
FpSpread1.ActiveSheet.Cells(3, 0, 5, 5).Text = "A"
See Also

Reference

FilterBar Class
FilterBar Members