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


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

    Property Value

    Cells object containing the cells 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