FarPoint.Win.SpreadJ アセンブリ > FarPoint.Win.Spread 名前空間 > DefaultRowFilter クラス : FilterFrozenRows プロパティ |
'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;}
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