Spread Windows Forms 6.0 Product Documentation
FilterInactiveDisabled Field
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SpreadView Class : FilterInactiveDisabled Field


Glossary Item Box

Specifies the index, 9, for the image for the disabled inactive filter indicator.

Syntax

Visual Basic (Declaration) 
Public Const FilterInactiveDisabled As Integer
Visual Basic (Usage)Copy Code
Dim value As Integer
 
value = SpreadView.FilterInactiveDisabled
C# 
public const int FilterInactiveDisabled

Field Value

Integer index corresponding to this part of the user interface

Remarks

The index for the disabled inactive filter inactive indicator is 9.

Example

This example sets the image for the specified field.
C#Copy Code
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 <= 3; i++)
    for (j = 0; j<= 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 BasicCopy Code
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

Requirements

Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2

See Also

© 2002-2012 ComponentOne, a division of GrapeCity. All Rights Reserved.