PowerTools SPREAD for ASP.NET 8.0J
FilterFrozenRows プロパティ (DefaultRowFilter)

固定行がフィルタリングされるかどうかを取得または設定します。
構文
'Declaration
 
Public Property FilterFrozenRows As Boolean
public bool FilterFrozenRows {get; set;}
次のサンプルコードでは、固定行は表示されますが、非表示行は表示されません。この動作を確認するには、行フィルタで5を選択します。
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;
}
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
参照

DefaultRowFilter クラス
DefaultRowFilter メンバ

 

 


© 2003-2015, GrapeCity inc. All rights reserved.