Spread Windows Forms 13.0 Product Documentation
FarPoint.Win.Spread Assembly / FarPoint.Win.Spread Namespace / SpreadView Class / FilterBarFilterActive Field
Example


In This Topic
    FilterBarFilterActive Field
    In This Topic
    Specifies the index, 16, for the image for the active filterbar indicator.
    Syntax
    'Declaration
     
    Public Const FilterBarFilterActive As Integer
    'Usage
     
    Dim value As Integer
     
    value = SpreadView.FilterBarFilterActive
    public const int FilterBarFilterActive
    Example
    This example sets the image before and after filtering a row.
    fpSpread1.Sheets[0].Columns[0].CellType = new FarPoint.Win.Spread.CellType.DateTimeCellType();
    fpSpread1.Sheets[0].Columns[1].CellType = new FarPoint.Win.Spread.CellType.NumberCellType();
    fpSpread1.Sheets[0].Columns[0, 2].AllowAutoFilter = true;
    fpSpread1.Sheets[0].AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.FilterBar;
    FarPoint.Win.Spread.SpreadView wrkbk = fpSpread1.GetRootWorkbook();
    wrkbk.SetImage(FarPoint.Win.Spread.SpreadView.FilterBarFilterActive, Image.FromFile("C:\\cut.png"));
    wrkbk.SetImage(FarPoint.Win.Spread.SpreadView.FilterBarFilterInactive, Image.FromFile("C:\\greencircle.png"));
    FpSpread1.Sheets(0).Columns(0).CellType = New FarPoint.Win.Spread.CellType.DateTimeCellType()
    FpSpread1.Sheets(0).Columns(1).CellType = New FarPoint.Win.Spread.CellType.NumberCellType()
    FpSpread1.Sheets(0).Columns(0, 2).AllowAutoFilter = True
    FpSpread1.Sheets(0).AutoFilterMode = FarPoint.Win.Spread.AutoFilterMode.FilterBar
    Dim wrkbk As FarPoint.Win.Spread.SpreadView = FpSpread1.GetRootWorkbook()
    wrkbk.SetImage(FarPoint.Win.Spread.SpreadView.FilterBarFilterActive, Image.FromFile("C:\cut.png"))
    wrkbk.SetImage(FarPoint.Win.Spread.SpreadView.FilterBarFilterInactive, Image.FromFile("C:\greencircle.png"))
    See Also