Spread ASP.NET 14
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / SheetCorner Class / AlternatingRows Property
Example


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

    Property Value

    AlternatingRows object containing the information for alternating the formatting of rows in the sheet corner
    Example
    This example modifies the appearance of the sheet corner.
    FarPoint.Web.Spread.Background bg = new FarPoint.Web.Spread.Background();
    bg.SelectedBackgroundImageUrl = "picture/Winter.jpg";
    bg.BackgroundImageUrl = "picture/Image.bmp";
    FpSpread1.SheetCorner.AlternatingRows.Count = 2;
    FpSpread1.SheetCorner.AlternatingRows[0].BackColor = Color.Pink;
    FpSpread1.SheetCorner.Cells[0, 0].Text = "Corner";
    FpSpread1.SheetCorner.ColumnCount = 3;
    FpSpread1.SheetCorner.RowCount = 3;
    FpSpread1.SheetCorner.Columns[1].CellType = new FarPoint.Web.Spread.CheckBoxCellType();
    FpSpread1.SheetCorner.Rows[1].Background = bg;
    // Define the default style name.
    FarPoint.Web.Spread.NamedStyle mnstyle = new FarPoint.Web.Spread.NamedStyle();
    mnstyle.Name = "fpstyle";
    mnstyle.BackColor = Color.Yellow;
    FpSpread1.NamedStyles.Add(mnstyle);
    FpSpread1.SheetCorner.DefaultStyleName = mnstyle.Name;
    // Define the default style.
    FarPoint.Web.Spread.StyleInfo mystyle = new FarPoint.Web.Spread.StyleInfo();
    mystyle.BackColor = Color.Red;
    FpSpread1.SheetCorner.DefaultStyle = mystyle;
    
    Dim bg As New FarPoint.Web.Spread.Background()
    bg.SelectedBackgroundImageUrl = "picture/Winter.jpg"
    bg.BackgroundImageUrl = "picture/Image.bmp"
    FpSpread1.SheetCorner.AlternatingRows.Count = 2
    FpSpread1.SheetCorner.AlternatingRows(0).BackColor = Color.Pink
    FpSpread1.SheetCorner.Cells(0, 0).Text = "Corner"
    FpSpread1.SheetCorner.ColumnCount = 3
    FpSpread1.SheetCorner.RowCount = 3
    FpSpread1.SheetCorner.Columns(1).CellType = New FarPoint.Web.Spread.CheckBoxCellType()
    FpSpread1.SheetCorner.Rows(1).Background = bg
    ' Define the default style name.
    Dim mnstyle As New FarPoint.Web.Spread.NamedStyle()
    mnstyle.Name = "fpstyle"
    mnstyle.BackColor = Color.Yellow
    FpSpread1.NamedStyles.Add(mnstyle)
    FpSpread1.SheetCorner.DefaultStyleName = mnstyle.Name
    ' Define the default style.
    Dim mystyle As New FarPoint.Web.Spread.StyleInfo()
    mystyle.BackColor = Color.Red
    FpSpread1.SheetCorner.DefaultStyle = mystyle
    See Also