RemoveColumn Method (DefaultRowFilter)

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.

Overload List

Overload	Description
RemoveColumn(Int32)	Removes a filter column definition from the row filter.

Example

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);
}

Visual Basic

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);
}

Visual Basic

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

Reference

DefaultRowFilter Class
DefaultRowFilter Members