Spread Windows Forms 11.0 Product Documentation
FilterFrozenRows Property (DefaultRowFilter)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > DefaultRowFilter Class : FilterFrozenRows Property
Gets or sets whether frozen rows are filtered.
Syntax
'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;}
Example
This example displays frozen rows, but does not display the hidden row.  Select 5 in the row filter to see this behavior.
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;
    }
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
See Also

Reference

DefaultRowFilter Class
DefaultRowFilter Members