FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class : GetFilterBarCellType Method |
'Declaration Public Overridable Function GetFilterBarCellType( _ ByVal column As Integer _ ) As ICellType
FarPoint.Win.Spread.SheetView sheetView = fpSpread1.ActiveSheet; sheetView.AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.FilterBar; sheetView.FilterBar.Cells[0].CellType = new FarPoint.Win.Spread.CellType.TextCellType(); sheetView.FilterBar.Cells[0].BackColor = Color.GreenYellow; sheetView.FilterBar.DefaultStyle.Border = new FarPoint.Win.DoubleLineBorder(Color.Yellow); listBox1.Items.Add(sheetView.GetFilterBarCellType(0));
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.TextCellType() sheetView.FilterBar.Cells(0).BackColor = Color.GreenYellow sheetView.FilterBar.DefaultStyle.Border = New FarPoint.Win.DoubleLineBorder(Color.Yellow) ListBox1.Items.Add(sheetView.GetFilterBarCellType(0))
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10