FilterFrozenRows Property (DefaultRowFilter)

Visual Basic
C#

'Declaration
 
Public Property FilterFrozenRows As Boolean

'Usage
 
Dim instance As DefaultRowFilter
Dim value As Boolean
 
instance.FilterFrozenRows = value
 
value = instance.FilterFrozenRows

public bool FilterFrozenRows {get; set;}

This example displays frozen rows, but does not display the hidden row. Select 5 in the row filter to see this behavior.

C#

private void Form1_Load(object sender, EventArgs e)
    {
        fpSpread1.ActiveSheet.RowCount = 10;
        for (int i = 0; i < 10; i++)
        {
            fpSpread1.ActiveSheet.SetValue(i, 0, i);
        }
        //fpSpread1.ActiveSheet.AutoFilterMode = AutoFilterMode.EnhancedContextMenu;
        fpSpread1.ActiveSheet.Columns[0].AllowAutoFilter = true;
        ((FarPoint.Win.Spread.HideRowFilter)fpSpread1.ActiveSheet.RowFilter).FilterFrozenRows = false;
        fpSpread1.ActiveSheet.FrozenRowCount = 3;
        fpSpread1.ActiveSheet.Rows[5].Visible = false;
    }

VB.NET

Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        FpSpread1.ActiveSheet.RowCount = 10
        For i As Integer = 0 To 9
            FpSpread1.ActiveSheet.SetValue(i, 0, i)
        Next
        'fpSpread1.ActiveSheet.AutoFilterMode = AutoFilterMode.EnhancedContextMenu;
        FpSpread1.ActiveSheet.Columns(0).AllowAutoFilter = True
        DirectCast(FpSpread1.ActiveSheet.RowFilter, FarPoint.Win.Spread.HideRowFilter).FilterFrozenRows = False
        FpSpread1.ActiveSheet.FrozenRowCount = 3
        FpSpread1.ActiveSheet.Rows(5).Visible = False
End Sub

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

DefaultRowFilter Class
DefaultRowFilter Members