Spread Windows Forms 11.0 Product Documentation
HideRowFilter Constructor
Example 


FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > HideRowFilter Class : HideRowFilter Constructor
Overload List
OverloadDescription
 
Creates a new row filter for the specified sheet that hides rows that match the criteria.  
Example
This example creates a filter that hides all rows but the filtered row.
FarPoint.Win.Spread.FilterColumnDefinition fcd = new FarPoint.Win.Spread.FilterColumnDefinition(1, FarPoint.Win.Spread.FilterListBehavior.SortByMostOccurrences
|  
FarPoint.Win.Spread.FilterListBehavior.Default);
FarPoint.Win.Spread.FilterColumnDefinition fcd1 = new FarPoint.Win.Spread.FilterColumnDefinition(2, FarPoint.Win.Spread.FilterListBehavior.Default);
FarPoint.Win.Spread.FilterColumnDefinition fcd2 = new FarPoint.Win.Spread.FilterColumnDefinition(3);
FarPoint.Win.Spread.HideRowFilter hf = new FarPoint.Win.Spread.HideRowFilter(fpSpread1.ActiveSheet);
hf.AddColumn(fcd);
hf.AddColumn(fcd1);
hf.AddColumn(fcd2);

fpSpread1.ActiveSheet.RowFilter = hf;
Dim fcd As New FarPoint.Win.Spread.FilterColumnDefinition(1, FarPoint.Win.Spread.FilterListBehavior.SortByMostOccurrences
Or FarPoint.Win.Spread.FilterListBehavior.Default)
Dim fcd1 As New FarPoint.Win.Spread.FilterColumnDefinition(2)
Dim fcd2 As New FarPoint.Win.Spread.FilterColumnDefinition(3)

Dim hf As New FarPoint.Win.Spread.HideRowFilter(fpSpread1.ActiveSheet)
hf.AddColumn(fcd)
hf.AddColumn(fcd1)
hf.AddColumn(fcd2)
fpSpread1.ActiveSheet.RowFilter = hf
See Also

Reference

HideRowFilter Class
HideRowFilter Members