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


In This Topic
    RowCount Property (SheetCorner)
    In This Topic
    Gets or sets the number of rows in the sheet corner.
    Syntax
    'Declaration
     
    Public Property RowCount As Integer
    'Usage
     
    Dim instance As SheetCorner
    Dim value As Integer
     
    instance.RowCount = value
     
    value = instance.RowCount
    public int RowCount {get; set;}

    Property Value

    Integer number of rows in the sheet corner
    Exceptions
    ExceptionDescription
    Specified row count is less than 0 or greater than 256.
    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