Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SheetView Class / GetFilterBarCellType Method
Column index of the cell
Example


In This Topic
    GetFilterBarCellType Method
    In This Topic
    Gets the composited (inherited) cell type for a specified cell on the filter bar.
    Syntax
    'Declaration
     
    Public Overridable Function GetFilterBarCellType( _
       ByVal column As Integer _
    ) As ICellType
    'Usage
     
    Dim instance As SheetView
    Dim column As Integer
    Dim value As ICellType
     
    value = instance.GetFilterBarCellType(column)
    public virtual ICellType GetFilterBarCellType( 
       int column
    )

    Parameters

    column
    Column index of the cell
    Example
    This example uses the GetFilterBarCellType method.
    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))
    See Also