FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > DefaultRowFilter Class > AddColumn Method : AddColumn(FilterColumnDefinition) Method |
'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 )
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"
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