Removes a filter column definition from the row filter.Removes a filter column definition from the row filter.
Removes a filter column definition from the row filter.
This example removes the specified column from being filtered.This example removes the specified column from being filtered.
fpSpread1.ActiveSheet.Columns[0].AllowAutoFilter = true;
FarPoint.Win.Spread.FilterColumnDefinition fcd = new FarPoint.Win.Spread.FilterColumnDefinition(1, FarPoint.Win.Spread.FilterListBehavior.Default);
fpSpread1.ActiveSheet.RowFilter.AddColumn(fcd);
DialogResult dlg = MessageBox.Show("Remove the column?");
if(dlg == DialogResult.OK)
{
fpSpread1.ActiveSheet.RowFilter.RemoveColumn(fcd);
}
FpSpread1.ActiveSheet.Columns(0).AllowAutoFilter = True
Dim fcd As New FarPoint.Win.Spread.FilterColumnDefinition(1, FarPoint.Win.Spread.FilterListBehavior.Default)
FpSpread1.ActiveSheet.RowFilter.AddColumn(fcd)
Dim dlg As DialogResult
dlg = MessageBox.Show("Remove the column?")
If dlg = DialogResult.OK Then
FpSpread1.ActiveSheet.RowFilter.RemoveColumn(fcd)
End If
fpSpread1.ActiveSheet.Columns[0].AllowAutoFilter = true;
FarPoint.Win.Spread.FilterColumnDefinition fcd = new FarPoint.Win.Spread.FilterColumnDefinition(1, FarPoint.Win.Spread.FilterListBehavior.Default);
fpSpread1.ActiveSheet.RowFilter.AddColumn(fcd);
DialogResult dlg = MessageBox.Show("Remove the column?");
if(dlg == DialogResult.OK)
{
fpSpread1.ActiveSheet.RowFilter.RemoveColumn(1);
}
FpSpread1.ActiveSheet.Columns(0).AllowAutoFilter = True
Dim fcd As New FarPoint.Win.Spread.FilterColumnDefinition(1, FarPoint.Win.Spread.FilterListBehavior.Default)
FpSpread1.ActiveSheet.RowFilter.AddColumn(fcd)
Dim dlg As DialogResult
dlg = MessageBox.Show("Remove the column?")
If dlg = DialogResult.OK Then
FpSpread1.ActiveSheet.RowFilter.RemoveColumn(1)
End If
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows Server 2012 R2, Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8, Windows 8.1, Windows 10