Spread ASP.NET 15
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetView Class / AlternatingRows Property

In This Topic
    AlternatingRows Property (SheetView)
    In This Topic
    Gets the alternating rows in the specified portion of the sheet.
    Public ReadOnly Property AlternatingRows As AlternatingRows
    Dim instance As SheetView
    Dim value As AlternatingRows
    value = instance.AlternatingRows
    public AlternatingRows AlternatingRows {get;}

    Property Value

    AlternatingRows object

    This property is available at run time only.

    Use this property to return the alternating rows settings object for the spreadsheet data area or the spreadsheet headers. The settings are returned in an AlternatingRows object.

    This example assigns a SheetView object to the active sheet and adds another Alternating Row to the default value of 2. The colors of the rows are each set to a new value.
    FarPoint.Web.Spread.SheetView sv = FpSpread1.ActiveSheetView;
    sv.AlternatingRows.Count = 3;
    sv.AlternatingRows[0].BackColor = Color.Yellow;
    sv.AlternatingRows[1].BackColor = Color.GreenYellow;
    sv.AlternatingRows[2].BackColor = Color.Tomato;
    Dim sv As FarPoint.Web.Spread.SheetView
    sv = FpSpread1.ActiveSheetView
    sv.AlternatingRows.Count = 3
    sv.AlternatingRows(0).BackColor = Color.Yellow
    sv.AlternatingRows(1).BackColor = Color.GreenYellow
    sv.AlternatingRows(2).BackColor = Color.Tomato
    See Also