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 Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10

Reference

SpreadView Class
SpreadView Members

User-Task Documentation

Customizing the User Interface Images