Spread Windows Forms 8.0 Product Documentation
HorizontalGridLine Property (FilterBar)
Example 


Gets or sets the GridLine object for the horizontal grid line in the filter bar.
Syntax
'Declaration
 
Public Property HorizontalGridLine As GridLine
'Usage
 
Dim instance As FilterBar
Dim value As GridLine
 
instance.HorizontalGridLine = value
 
value = instance.HorizontalGridLine
public GridLine HorizontalGridLine {get; set;}
Example
This example sets the HorizontalGridLine 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"
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

Reference

FilterBar Class
FilterBar Members

 

 


Copyright © GrapeCity, inc. All rights reserved.