Col Property | Spread ASP.NET 15

Col Property

In This Topic

Gets or sets the filter column.

Syntax

Visual Basic
C#

'Declaration
 
Public Property Col As Integer

'Usage
 
Dim instance As AutoFilteredColumnEventArgs
Dim value As Integer
 
instance.Col = value
 
value = instance.Col

public int Col {get; set;}

Example

This example uses the AutoFilteredColumn event.

protected void Page_Load(object sender, EventArgs e)
   {
     FarPoint.Web.Spread.NamedStyle instyle = new FarPoint.Web.Spread.NamedStyle();
     FarPoint.Web.Spread.NamedStyle outstyle = new FarPoint.Web.Spread.NamedStyle();
     instyle.BackColor = System.Drawing.Color.Yellow;
     outstyle.BackColor = System.Drawing.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].Cells[0, 1].Value = "test";
  }

protected void FpSpread1_AutoFilteringColumn(object sender, FarPoint.Web.Spread.FilteringEventArgs e)
  {
     FpSpread1.Sheets[0].Cells[0, 0].Text = e.FilterString;
     FpSpread1.Sheets[0].Cells[1, 0].Text = e.Col.ToString();
  }
protected void FpSpread1_AutoFilteredColumn(object sender, FarPoint.Web.Spread.FilteredEventArgs e)
  {
     FpSpread1.Sheets[0].Cells[0, 0].Text = e.FilterString;
     FpSpread1.Sheets[0].Cells[1, 0].Text = e.Col.ToString();
  }

VB.NET

Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
  Dim instyle As New FarPoint.Web.Spread.NamedStyle()
  Dim outstyle As New FarPoint.Web.Spread.NamedStyle()
  instyle.BackColor = Drawing.Color.Yellow
  outstyle.BackColor = Drawing.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).Cells(0, 1).Value = "test"
End Sub

Protected Sub FpSpread1_AutoFilteringColumn(ByVal sender As Object, ByVal e As FarPoint.Web.Spread.FilteringEventArgs) Handles FpSpread1.AutoFilteringColumn
    FpSpread1.Sheets(0).Cells(0, 0).Text = e.FilterString
    FpSpread1.Sheets(0).Cells(1, 0).Text = e.Col.ToString()
End Sub

Protected Sub FpSpread1_AutoFilteredColumn(ByVal sender As Object, ByVal e As FarPoint.Web.Spread.FilteredEventArgs) Handles FpSpread1.AutoFilteredColumn
    FpSpread1.Sheets(0).Cells(0, 0).Text = e.FilterString
    FpSpread1.Sheets(0).Cells(1, 0).Text = e.Col.ToString()
End Sub

Reference

AutoFilteredColumnEventArgs Class
AutoFilteredColumnEventArgs Members

Product Support Forum | Print this page