Spread for ASP.NET 13 Product Documentation
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / ColumnHeader Class / AlternatingRows Property
Example


In This Topic
    AlternatingRows Property (ColumnHeader)
    In This Topic
    Gets the alternating rows information for the column header.
    Syntax
    'Declaration
     
    Public ReadOnly Property AlternatingRows As AlternatingRows
    'Usage
     
    Dim instance As ColumnHeader
    Dim value As AlternatingRows
     
    value = instance.AlternatingRows
    public AlternatingRows AlternatingRows {get;}

    Property Value

    AlternatingRows object containing the alternating rows for this column header
    Example
    This example sets up the alternating rows of the sheet and assigns different background colors to those rows, and then returns  to a list box the number of alternating rows in the column header.
    FarPoint.Web.Spread.ColumnHeader colhdr;
    FpSpread1.ActiveSheetView.AlternatingRows[0].BackColor = Color.Yellow;
    FpSpread1.ActiveSheetView.AlternatingRows[1].BackColor = Color.GreenYellow;
    colhdr = FpSpread1.ActiveSheetView.ColumnHeader;
    TextBox1.Text = Convert.ToString(colhdr.AlternatingRows.Count); 
    Dim colhdr As FarPoint.Web.Spread.ColumnHeader
    FpSpread1.ActiveSheetView.AlternatingRows(0).BackColor = Color.Yellow
    FpSpread1.ActiveSheetView.AlternatingRows(1).BackColor = Color.GreenYellow
    colhdr = FpSpread1.ActiveSheetView.ColumnHeader
    TextBox1.Text = Convert.ToString(colhdr.AlternatingRows.Count)
    See Also