FilterFrozenRows Property (DefaultRowFilter)

In This Topic

Gets or sets whether frozen rows are filtered.

Syntax

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

Example

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;
            hf.AddColumn(fcd);           
            FpSpread1.Sheets[0].RowFilter = hf;                    
            FpSpread1.ActiveSheetView.FrozenRowCount = 3;
            FpSpread1.ActiveSheetView.Rows[5].Visible = false;           
        }

VB.NET

Private Sub Page_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load, Me.Load
            If (IsPostBack) Then
                Return
            End If
            FpSpread1.ActiveSheetView.RowCount = 10
            For i As Integer = 0 To 9
                FpSpread1.ActiveSheetView.SetValue(i, 0, i)
            Next
            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
            hf.AddColumn(fcd)
            FpSpread1.Sheets(0).RowFilter = hf
            FpSpread1.ActiveSheetView.FrozenRowCount = 3
            FpSpread1.ActiveSheetView.Rows(5).Visible = False
        End Sub

Reference

DefaultRowFilter Class
DefaultRowFilter Members

Product Support Forum | Print this page