作成日: 2019/06/27 最終更新日: 2019/06/27
文書種別
使用方法
詳細
フィルタリングされた状態では、セルの値が変更されるたびにフィルタリング処理が実行されます。シートのAutoFilterプロパティをFalseに設定することで、ユーザーが明示的にフィルタリングを実行しない限り、セルの値変更時にフィルタリング処理が実行されなくなります。
◎サンプルコード(VB)
◎サンプルコード(C#)
◎サンプルコード(VB)
Private Sub Form1_Load(sender As Object, e As EventArgs) Handles MyBase.Load
' 値の変更時にフィルタリングを自動実行しない
FpSpread1.ActiveSheet.AutoFilter = False
' 1列目でフィルタリングを許可
FpSpread1.ActiveSheet.Columns(0).AllowAutoFilter = True
FpSpread1.ActiveSheet.Cells(0, 0).Value = "North"
FpSpread1.ActiveSheet.Cells(1, 0).Value = "South"
FpSpread1.ActiveSheet.Cells(2, 0).Value = "East"
FpSpread1.ActiveSheet.Cells(3, 0).Value = "South"
FpSpread1.ActiveSheet.Cells(4, 0).Value = "North"
FpSpread1.ActiveSheet.Cells(5, 0).Value = "North"
FpSpread1.ActiveSheet.Cells(6, 0).Value = "West"
FpSpread1.ActiveSheet.Columns(0).Width = 80
' 1列目を"North"でフィルタリング
FpSpread1.ActiveSheet.AutoFilterColumn(0, "North", 0)
End Sub
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
' A1セルの値を変更
FpSpread1.ActiveSheet.Cells(0, 0).Value = "South"
End Sub
Private Sub FpSpread1_AutoFilteringColumn(sender As Object, e As FarPoint.Win.Spread.AutoFilteringColumnEventArgs) Handles FpSpread1.AutoFilteringColumn
Console.WriteLine("AutoFilteringColumnイベントの確認")
End Sub
Private Sub FpSpread1_AutoFilteredColumn(sender As Object, e As FarPoint.Win.Spread.AutoFilteredColumnEventArgs) Handles FpSpread1.AutoFilteredColumn
Console.WriteLine("AutoFilteredColumnイベントの確認")
End Sub
' 値の変更時にフィルタリングを自動実行しない
FpSpread1.ActiveSheet.AutoFilter = False
' 1列目でフィルタリングを許可
FpSpread1.ActiveSheet.Columns(0).AllowAutoFilter = True
FpSpread1.ActiveSheet.Cells(0, 0).Value = "North"
FpSpread1.ActiveSheet.Cells(1, 0).Value = "South"
FpSpread1.ActiveSheet.Cells(2, 0).Value = "East"
FpSpread1.ActiveSheet.Cells(3, 0).Value = "South"
FpSpread1.ActiveSheet.Cells(4, 0).Value = "North"
FpSpread1.ActiveSheet.Cells(5, 0).Value = "North"
FpSpread1.ActiveSheet.Cells(6, 0).Value = "West"
FpSpread1.ActiveSheet.Columns(0).Width = 80
' 1列目を"North"でフィルタリング
FpSpread1.ActiveSheet.AutoFilterColumn(0, "North", 0)
End Sub
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
' A1セルの値を変更
FpSpread1.ActiveSheet.Cells(0, 0).Value = "South"
End Sub
Private Sub FpSpread1_AutoFilteringColumn(sender As Object, e As FarPoint.Win.Spread.AutoFilteringColumnEventArgs) Handles FpSpread1.AutoFilteringColumn
Console.WriteLine("AutoFilteringColumnイベントの確認")
End Sub
Private Sub FpSpread1_AutoFilteredColumn(sender As Object, e As FarPoint.Win.Spread.AutoFilteredColumnEventArgs) Handles FpSpread1.AutoFilteredColumn
Console.WriteLine("AutoFilteredColumnイベントの確認")
End Sub
◎サンプルコード(C#)
private void Form1_Load(object sender, EventArgs e)
{
// 値の変更時にフィルタリングを自動実行しない
fpSpread1.ActiveSheet.AutoFilter = false;
// 1列目でフィルタリングを許可
fpSpread1.ActiveSheet.Columns[0].AllowAutoFilter = true;
fpSpread1.ActiveSheet.Cells[0, 0].Value = "North";
fpSpread1.ActiveSheet.Cells[1, 0].Value = "South";
fpSpread1.ActiveSheet.Cells[2, 0].Value = "East";
fpSpread1.ActiveSheet.Cells[3, 0].Value = "South";
fpSpread1.ActiveSheet.Cells[4, 0].Value = "North";
fpSpread1.ActiveSheet.Cells[5, 0].Value = "North";
fpSpread1.ActiveSheet.Cells[6, 0].Value = "West";
fpSpread1.ActiveSheet.Columns[0].Width = 80;
// 1列目を"North"でフィルタリング
fpSpread1.ActiveSheet.AutoFilterColumn(0, "North", 0);
}
private void button1_Click(object sender, EventArgs e)
{
// A1セルの値を変更
fpSpread1.ActiveSheet.Cells[0, 0].Value = "South";
}
void fpSpread1_AutoFilteringColumn(object sender, FarPoint.Win.Spread.AutoFilteringColumnEventArgs e)
{
Console.WriteLine("AutoFilteringColumnイベントの確認");
}
void fpSpread1_AutoFilteredColumn(object sender, FarPoint.Win.Spread.AutoFilteredColumnEventArgs e)
{
Console.WriteLine("AutoFilteredColumnイベントの確認");
}
{
// 値の変更時にフィルタリングを自動実行しない
fpSpread1.ActiveSheet.AutoFilter = false;
// 1列目でフィルタリングを許可
fpSpread1.ActiveSheet.Columns[0].AllowAutoFilter = true;
fpSpread1.ActiveSheet.Cells[0, 0].Value = "North";
fpSpread1.ActiveSheet.Cells[1, 0].Value = "South";
fpSpread1.ActiveSheet.Cells[2, 0].Value = "East";
fpSpread1.ActiveSheet.Cells[3, 0].Value = "South";
fpSpread1.ActiveSheet.Cells[4, 0].Value = "North";
fpSpread1.ActiveSheet.Cells[5, 0].Value = "North";
fpSpread1.ActiveSheet.Cells[6, 0].Value = "West";
fpSpread1.ActiveSheet.Columns[0].Width = 80;
// 1列目を"North"でフィルタリング
fpSpread1.ActiveSheet.AutoFilterColumn(0, "North", 0);
}
private void button1_Click(object sender, EventArgs e)
{
// A1セルの値を変更
fpSpread1.ActiveSheet.Cells[0, 0].Value = "South";
}
void fpSpread1_AutoFilteringColumn(object sender, FarPoint.Win.Spread.AutoFilteringColumnEventArgs e)
{
Console.WriteLine("AutoFilteringColumnイベントの確認");
}
void fpSpread1_AutoFilteredColumn(object sender, FarPoint.Win.Spread.AutoFilteredColumnEventArgs e)
{
Console.WriteLine("AutoFilteredColumnイベントの確認");
}
旧文書番号
84139