Cells Property (SheetCorner)

Visual Basic
C#

'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

This example modifies the appearance of the sheet corner.

C#

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;

Visual Basic

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

Target Platforms: Windows 7, Windows 8, Windows 10, Windows Vista, Windows Server 2003, Windows Server 2008, Windows Server 2012, Windows XP Professional

Reference

SheetCorner Class
SheetCorner Members