Spread Windows Forms 9.0 Product Documentation
RemoveColumn Method (DefaultRowFilter)
Example 


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

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

See Also

Reference

DefaultRowFilter Class
DefaultRowFilter Members

 

 


Copyright © GrapeCity, inc. All rights reserved.