FilterBarFilterActive Field

Specifies the index, 16, for the image for the active filterbar indicator.

Syntax

Visual Basic
C#

'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"));

Visual Basic

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"))

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

Reference

SpreadView Class
SpreadView Members