Spread Windows Forms 11.0 Product Documentation
FilterBarFilterActive Field
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SpreadView Class : FilterBarFilterActive Field
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

Reference

SpreadView Class
SpreadView Members