RowFilter Property

Visual Basic
C#

'Declaration
 
Public Property RowFilter As IRowFilter

'Usage
 
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#

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

fcdc.Add(fcd);
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 Basic

Dim fcdc As New FarPoint.Win.Spread.FilterColumnDefinitionCollection
Dim fcd As New FarPoint.Win.Spread.FilterColumnDefinition(1, FarPoint.Win.Spread.FilterListBehavior.Default)
fcdc.Add(fcd)
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 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

SheetView Class
SheetView Members

User-Task Documentation

Managing Filtering of Rows of User Data