FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > FilterBar Class : 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"
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8