Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / FilterBar Class / VerticalGridLine Property
Example


In This Topic
    VerticalGridLine Property (FilterBar)
    In This Topic
    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