Spread Windows Forms 11.0 Product Documentation
Filter Method (TableView)
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > TableView Class : Filter Method
Index
Filter item
Filters a column in the table.
Syntax
'Declaration
 
Public Sub Filter( _
   ByVal column As Integer, _
   ByVal activeFilter As IFilterItem _
) 
'Usage
 
Dim instance As TableView
Dim column As Integer
Dim activeFilter As IFilterItem
 
instance.Filter(column, activeFilter)
public void Filter( 
   int column,
   IFilterItem activeFilter
)

Parameters

column
Index
activeFilter
Filter item
Example
This example filters a table.
FarPoint.Win.Spread.TableStyle tstyle = fpSpread1.CreateTableStyle("Style1", FarPoint.Win.Spread.TableStyle.TableStyleLight2);
fpSpread1.Sheets[0].Cells[1, 1].Text = "Last Name";
fpSpread1.Sheets[0].Cells[1, 2].Text = "Value";
fpSpread1.Sheets[0].Cells[2, 1].Text = "Smith";
fpSpread1.Sheets[0].Cells[2, 2].Value = 50;
fpSpread1.Sheets[0].Cells[3, 1].Text = "Vil";
fpSpread1.Sheets[0].Cells[3, 2].Value = 10;
fpSpread1.Sheets[0].Cells[4, 1].Text = "Press";
fpSpread1.Sheets[0].Cells[4, 2].Value = 78;
fpSpread1.TableStyleCollection.Add(tstyle);
FarPoint.Win.Spread.TableView table = fpSpread1.Sheets[0].AddTable("table", 1, 1, 5, 2, "Style1");

FarPoint.Win.Spread.FilterItemValue test = new FarPoint.Win.Spread.FilterItemValue("Vil");
FarPoint.Win.Spread.FilterItemValue test1 = new FarPoint.Win.Spread.FilterItemValue("Press");
FarPoint.Win.Spread.MultiValuesFilterItem multifilter = new FarPoint.Win.Spread.MultiValuesFilterItem(new FarPoint.Win.Spread.FilterItemValue[] { test, test1 });
//Use the customized filter by implementing IFilterItem and setting the filterItem to the table column.
table.Filter(0, multifilter);// filter first column with filter item created above.
Dim tstyle As FarPoint.Win.Spread.TableStyle
tstyle = FpSpread1.CreateTableStyle("Style1", FarPoint.Win.Spread.TableStyle.TableStyleLight2)
FpSpread1.Sheets(0).Cells(1, 1).Text = "Last Name"
FpSpread1.Sheets(0).Cells(1, 2).Text = "Value"
FpSpread1.Sheets(0).Cells(2, 1).Text = "Smith"
FpSpread1.Sheets(0).Cells(2, 2).Value = 50
FpSpread1.Sheets(0).Cells(3, 1).Text = "Vil"
FpSpread1.Sheets(0).Cells(3, 2).Value = 10
FpSpread1.Sheets(0).Cells(4, 1).Text = "Press"
FpSpread1.Sheets(0).Cells(4, 2).Value = 78
Dim table As FarPoint.Win.Spread.TableView = FpSpread1.Sheets(0).AddTable("table", 1, 1, 5, 2, "Style1")
Dim test As FarPoint.Win.Spread.FilterItemValue
test = New FarPoint.Win.Spread.FilterItemValue("Vil")
Dim test1 As FarPoint.Win.Spread.FilterItemValue
test1 = New FarPoint.Win.Spread.FilterItemValue("Press")
Dim multifilter As New FarPoint.Win.Spread.MultiValuesFilterItem(New FarPoint.Win.Spread.FilterItemValue() {test, test1})
'Use the customized filter by implementing IFilterItem and setting the filterItem to the table column.
table.Filter(0, multifilter) 'filter first column with filter item created above.
See Also

Reference

TableView Class
TableView Members