Spread for ASP.NET 8.0 Product Documentation
AddColumn(FilterColumnDefinition) Method
Example 


FilterColumnDefinition object that contains the filter column definition
Adds a filter column definition to the row filter.
Syntax
'Declaration
 
Public Overloads Sub AddColumn( _
   ByVal fcd As FilterColumnDefinition _
) 
'Usage
 
Dim instance As DefaultRowFilter
Dim fcd As FilterColumnDefinition
 
instance.AddColumn(fcd)
public void AddColumn( 
   FilterColumnDefinition fcd
)

Parameters

fcd
FilterColumnDefinition object that contains the filter column definition
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.Gray;
FarPoint.Web.Spread.StyleRowFilter rf = new FarPoint.Web.Spread.StyleRowFilter(FpSpread1.Sheets[0], instyle, outstyle);
FpSpread1.Sheets[0].RowFilter = rf; 
// Assign filter and customize filter options
FpSpread1.Sheets[0].RowFilter.AddColumn(1);
FpSpread1.Sheets[0].RowFilter.ShowFilterIndicator = true;
FpSpread1.Sheets[0].RowFilter.AllString = "Show All";
FpSpread1.Sheets[0].RowFilter.BlanksString = "Show The Blanks";
FpSpread1.Sheets[0].RowFilter.NonBlanksString = "Show The Non-Blanks";
Dim instyle As New FarPoint.Web.Spread.NamedStyle()
Dim outstyle As New FarPoint.Web.Spread.NamedStyle()
instyle.BackColor = Color.Yellow
outstyle.BackColor = Color.Gray
Dim rf As New FarPoint.Web.Spread.StyleRowFilter(FpSpread1.Sheets(0), instyle, outstyle) 
FpSpread1.Sheets(0).RowFilter = rf
' Assign filter and customize filter options
FpSpread1.Sheets(0).RowFilter.AddColumn(1)
FpSpread1.Sheets(0).RowFilter.ShowFilterIndicator = True
FpSpread1.Sheets(0).RowFilter.AllString = "Show All"
FpSpread1.Sheets(0).RowFilter.BlanksString = "Show The Blanks"
FpSpread1.Sheets(0).RowFilter.NonBlanksString = "Show The Non-Blanks"
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

See Also

Reference

DefaultRowFilter Class
DefaultRowFilter Members
Overload List

 

 


Copyright © GrapeCity, inc. All rights reserved.