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


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

    Property Value

    Rows object containing the 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