FilterInactive Field

Visual Basic
C#

'Declaration
 
Public Const FilterInactive As Integer

'Usage
 
Dim value As Integer
 
value = SpreadView.FilterInactive

public const int FilterInactive

Field Value

Integer index corresponding to this part of the user interface

This example sets the image for the specified field.

C#

FarPoint.Win.Spread.SpreadView workbook = fpSpread1.GetRootworkbook(); 
workbook.SetImage(FarPoint.Win.Spread.SpreadView.FilterActive, Image.FromFile("D:\filter-act-enable.bmp")); 
workbook.SetImage(FarPoint.Win.Spread.SpreadView.FilterActiveDisabled, Image.FromFile("D:\filter-act-disable.bmp")); 
workbook.SetImage(FarPoint.Win.Spread.SpreadView.FilterInactive, Image.FromFile("D:\filter-inact-ena.bmp")); 
workbook.SetImage(FarPoint.Win.Spread.SpreadView.FilterInactiveDisabled, Image.FromFile("D:\filter-inact-dis.bmp")); 

Random r = new Random();
int i, j = 0;
for (i = 0; i &lt;= 3; i++)
    for (j = 0; j&lt;= 3; j++)
    {
        fpSpread1.ActiveSheet.SetValue(i, j, r.Next().ToString());
    }

fpSpread1.ActiveSheet.Columns[0].AllowAutoFilter = true;

Image indicator;
indicator = workbook.GetImage(4);
pictureBox1.Image = indicator;

Visual Basic

Dim workbook As FarPoint.Win.Spread.SpreadView = FpSpread1.GetRootworkbook()
workbook.SetImage(workbook.FilterActive, Image.FromFile("D:\filter-act-enable.bmp"))
workbook.SetImage(workbook.FilterActiveDisabled, Image.FromFile("D:\filter-act-disable.bmp"))
workbook.SetImage(workbook.FilterInactive, Image.FromFile("D:\filter-inact-ena.bmp"))
workbook.SetImage(workbook.FilterInactiveDisabled, Image.FromFile("D:\filter-inact-dis.bmp"))

Dim r As New Random
Dim i, j As Integer
For i = 0 To 3
    For j = 0 To 3
        FpSpread1.ActiveSheet.SetValue(i, j, r.Next.ToString())
    Next j
Next i

FpSpread1.ActiveSheet.Columns(0).AllowAutoFilter = True

Dim indicator As Image
indicator = workbook.GetImage(4)
PictureBox1.Image = indicator

The index for the enabled inactive filter indicator is 8.

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

User-Task Documentation

Customizing the User Interface Images