Spread Windows Forms 6.0 Product Documentation
RowFilter Property
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SheetView Class : RowFilter Property

Glossary Item Box

Gets or sets the row filter for the sheet.


Visual Basic (Declaration) 
Public Property RowFilter As IRowFilter
Visual Basic (Usage)Copy Code
Dim instance As SheetView
Dim value As IRowFilter
instance.RowFilter = value
value = instance.RowFilter
public IRowFilter RowFilter {get; set;}

Property Value

IRowFilter object containing the row filter


This example gets the filter for the sheet.
C#Copy Code
FarPoint.Win.Spread.FilterColumnDefinitionCollection fcdc = new FarPoint.Win.Spread.FilterColumnDefinitionCollection();
FarPoint.Win.Spread.FilterColumnDefinition fcd = new FarPoint.Win.Spread.FilterColumnDefinition(1, FarPoint.Win.Spread.FilterListBehavior.Default);

FarPoint.Win.Spread.NamedStyle instyle = new FarPoint.Win.Spread.NamedStyle();
FarPoint.Win.Spread.NamedStyle outstyle = new FarPoint.Win.Spread.NamedStyle();
instyle.BackColor = Color.Yellow;
outstyle.BackColor = Color.Gray;
FarPoint.Win.Spread.StyleRowFilter rf = new FarPoint.Win.Spread.StyleRowFilter(fpSpread1.ActiveSheet, fcdc, instyle, outstyle);

fpSpread1.ActiveSheet.RowFilter = rf;

if (rf != null)
    DialogResult dlg;
    dlg = MessageBox.Show("Set the filter??");
    if (dlg == DialogResult.OK)
        textBox1.Text = fpSpread1.ActiveSheet.RowFilter().ToString();
Visual BasicCopy Code
Dim fcdc As New FarPoint.Win.Spread.FilterColumnDefinitionCollection
Dim fcd As New FarPoint.Win.Spread.FilterColumnDefinition(1, FarPoint.Win.Spread.FilterListBehavior.Default)
Dim instyle As New FarPoint.Win.Spread.NamedStyle
Dim outstyle As New FarPoint.Win.Spread.NamedStyle
instyle.BackColor = Color.Yellow
outstyle.BackColor = Color.Gray
Dim rf As New FarPoint.Win.Spread.StyleRowFilter(FpSpread1.ActiveSheet, fcdc, instyle, outstyle)

FpSpread1.ActiveSheet.RowFilter = sf

If Not rf Is Nothing Then
    Dim dlg As DialogResult
    dlg = MessageBox.Show("Set the filter??")
    If dlg = DialogResult.OK Then
        TextBox1.Text = FpSpread1.ActiveSheet.RowFilter().ToString
    End If
End If


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.