Spread for ASP.NET 11 Product Documentation
AlternatingRows Property (SheetCorner)
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > SheetCorner Class : AlternatingRows Property
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

Reference

SheetCorner Class
SheetCorner Members