PowerTools SPREAD for Windows Forms 10.0J
FilterFrozenRows プロパティ (DefaultRowFilter)


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

DefaultRowFilter クラス
DefaultRowFilter メンバ

 

 


© 2004-2017, GrapeCity inc. All rights reserved.