Spread ASP.NET 15
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / DefaultRowFilter Class / FilterFrozenRows Property

In This Topic
    FilterFrozenRows Property (DefaultRowFilter)
    In This Topic
    Gets or sets whether frozen rows are filtered.
    Public Property FilterFrozenRows As Boolean
    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.
    protected void Page_Load(object sender, EventArgs e)
                if (this.IsPostBack) return;
                FpSpread1.ActiveSheetView.RowCount = 10;
                for (int i = 0; i < 10; i++)
                    FpSpread1.ActiveSheetView.SetValue(i, 0, i);
                FarPoint.Web.Spread.FilterColumnDefinition fcd = new FarPoint.Web.Spread.FilterColumnDefinition(0, FarPoint.Web.Spread.FilterListBehavior.SortByMostOccurrences | FarPoint.Web.Spread.FilterListBehavior.Default);
                FarPoint.Web.Spread.HideRowFilter hf = new FarPoint.Web.Spread.HideRowFilter(FpSpread1.Sheets[0]);
                hf.FilterFrozenRows = false;
                FpSpread1.Sheets[0].RowFilter = hf;                    
                FpSpread1.ActiveSheetView.FrozenRowCount = 3;
                FpSpread1.ActiveSheetView.Rows[5].Visible = false;           
    Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load, Me.Load
                If (IsPostBack) Then
                End If
                FpSpread1.ActiveSheetView.RowCount = 10
                For i As Integer = 0 To 9
                    FpSpread1.ActiveSheetView.SetValue(i, 0, i)
                Dim fcd As New FarPoint.Web.Spread.FilterColumnDefinition(0, FarPoint.Web.Spread.FilterListBehavior.SortByMostOccurrences Or FarPoint.Web.Spread.FilterListBehavior.[Default])
                Dim hf As New FarPoint.Web.Spread.HideRowFilter(FpSpread1.Sheets(0))
                hf.FilterFrozenRows = False
                FpSpread1.Sheets(0).RowFilter = hf
                FpSpread1.ActiveSheetView.FrozenRowCount = 3
                FpSpread1.ActiveSheetView.Rows(5).Visible = False
            End Sub
    See Also