FarPoint.Win.SpreadJ アセンブリ > FarPoint.Win.Spread 名前空間 > FilterBar クラス : DefaultStyle プロパティ |
//Customize "Cells" in Filter Bar FarPoint.Win.Spread.SheetView sheetView = fpSpread1.ActiveSheet; sheetView.AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.FilterBar; sheetView.FilterBar.Cells[0].Border = new FarPoint.Win.DoubleLineBorder(Color.Red); sheetView.FilterBar.Cells[0].BackColor = Color.GreenYellow; sheetView.FilterBar.Cells[0].CellType = new FarPoint.Win.Spread.CellType.FilterBarCellType(); sheetView.FilterBar.DefaultStyle.Border = new FarPoint.Win.DoubleLineBorder(Color.Yellow); FarPoint.Win.Spread.CellType.FilterBarCellType cellType = new FarPoint.Win.Spread.CellType.FilterBarCellType(); cellType.ShowDropDownMenuStrip = false; sheetView.FilterBar.Cells[3].CellType = cellType; sheetView.FilterBar.Height = 30; sheetView.FilterBarHeaderStyle.Border = new FarPoint.Win.DoubleLineBorder(Color.Red); sheetView.FilterBarHeaderStyle.BackColor = Color.Yellow; fpSpread1.ActiveSheet.Cells[0, 0, 2, 5].Text = "Test"; fpSpread1.ActiveSheet.Cells[3, 0, 5, 5].Text = "A";
'Customize "Cells" in Filter Bar Dim sheetView As FarPoint.Win.Spread.SheetView = FpSpread1.ActiveSheet sheetView.AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.FilterBar sheetView.FilterBar.Cells(0).Border = New FarPoint.Win.DoubleLineBorder(Color.Red) sheetView.FilterBar.Cells(0).BackColor = Color.GreenYellow sheetView.FilterBar.Cells(0).CellType = New FarPoint.Win.Spread.CellType.FilterBarCellType() sheetView.FilterBar.DefaultStyle.Border = New FarPoint.Win.DoubleLineBorder(Color.Yellow) Dim cellType As New FarPoint.Win.Spread.CellType.FilterBarCellType() cellType.ShowDropDownMenuStrip = False sheetView.FilterBar.Cells(3).CellType = cellType sheetView.FilterBar.Height = 30 sheetView.FilterBarHeaderStyle.Border = New FarPoint.Win.DoubleLineBorder(Color.Red) sheetView.FilterBarHeaderStyle.BackColor = Color.Yellow FpSpread1.ActiveSheet.Cells(0, 0, 2, 5).Text = "Test" FpSpread1.ActiveSheet.Cells(3, 0, 5, 5).Text = "A"