StyleRowFilter Constructor(SheetView,NamedStyle,NamedStyle)

Creates a new style row filter for the specified sheet with specified styles.

Syntax

Visual Basic
C#

'Declaration
 
Public Function New( _
   ByVal sheetView As SheetView, _
   ByVal inStyle As NamedStyle, _
   ByVal outStyle As NamedStyle _
)

'Usage
 
Dim sheetView As SheetView
Dim inStyle As NamedStyle
Dim outStyle As NamedStyle
 
Dim instance As New StyleRowFilter(sheetView, inStyle, outStyle)

public StyleRowFilter( 
   SheetView sheetView,
   NamedStyle inStyle,
   NamedStyle outStyle
)

Parameters

sheetView: SheetView object that contains the sheet
inStyle: Style for items filtered in
outStyle: Style for items filtered out

Example

This example sets a row filter.

FarPoint.Web.Spread.NamedStyle instyle = new FarPoint.Web.Spread.NamedStyle(); 
FarPoint.Web.Spread.NamedStyle outstyle = new FarPoint.Web.Spread.NamedStyle();
instyle.BackColor = Color.Yellow;
outstyle.BackColor = Color.Aquamarine; 
FarPoint.Web.Spread.FilterColumnDefinition fcd = new FarPoint.Web.Spread.FilterColumnDefinition(1, FarPoint.Web.Spread.FilterListBehavior.SortByMostOccurrences | FarPoint.Web.Spread.FilterListBehavior.Default); 
FarPoint.Web.Spread.FilterColumnDefinition fcd1 = new FarPoint.Web.Spread.FilterColumnDefinition(2);
FarPoint.Web.Spread.FilterColumnDefinition fcd2 = new FarPoint.Web.Spread.FilterColumnDefinition();
FarPoint.Web.Spread.StyleRowFilter sf = new FarPoint.Web.Spread.StyleRowFilter(FpSpread1.Sheets[0], instyle, outstyle);
sf.AddColumn(fcd);
sf.AddColumn(fcd1); 
sf.AddColumn(fcd2);
FpSpread1.Sheets[0].RowFilter = sf;

Visual Basic

Dim instyle As New FarPoint.Web.Spread.NamedStyle()
Dim outstyle As New FarPoint.Web.Spread.NamedStyle()
instyle.BackColor = Color.Yellow
outstyle.BackColor = Color.Aquamarine
Dim fcd As New FarPoint.Web.Spread.FilterColumnDefinition(1, FarPoint.Web.Spread.FilterListBehavior.SortByMostOccurrences Or FarPoint.Web.Spread.FilterListBehavior.Default)
Dim fcd1 As New FarPoint.Web.Spread.FilterColumnDefinition(2)
Dim fcd2 As New FarPoint.Web.Spread.FilterColumnDefinition()
Dim sf As New FarPoint.Web.Spread.StyleRowFilter(FpSpread1.Sheets(0), instyle, outstyle)
sf.AddColumn(fcd) 
sf.AddColumn(fcd1)
sf.AddColumn(fcd2)
FpSpread1.Sheets(0).RowFilter = sf

Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

Reference

StyleRowFilter Class
StyleRowFilter Members
Overload List