Gets or sets whether frozen rows are filtered.
Syntax
Visual Basic (Declaration) | |
---|
Public Property FilterFrozenRows As Boolean |
Visual Basic (Usage) | Copy Code |
---|
Dim instance As DefaultRowFilter
Dim value As Boolean
instance.FilterFrozenRows = value
value = instance.FilterFrozenRows |
C# | |
---|
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.
C# | Copy Code |
---|
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 | Copy Code |
---|
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 |
Requirements
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6
See Also