Spread for ASP.NET 11 Product Documentation
BackColor Property (Row)
Example 


FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > Row Class : BackColor Property
Gets or sets the background color for cells in this row.
Syntax
'Declaration
 
Public Property BackColor As Color
'Usage
 
Dim instance As Row
Dim value As Color
 
instance.BackColor = value
 
value = instance.BackColor
public Color BackColor {get; set;}

Property Value

Color object that contains the background color for cells in this row
Remarks

The setting for this property can be overridden if a named style is assigned to the cell using the StyleName property, and that named style sets the background color.

Specify the text color for the cell by setting the ForeColor property.

Example
This example creates a spreadsheet with 10 columns and 20 rows. A Row object is then created and assigned to all the rows of the sheet. The background color, foreground color, font face, and height properties are set to various values, and the text inserted into the rows reflects the changes.
FpSpread1.ActiveSheetView.ColumnCount = 10;
FpSpread1.ActiveSheetView.PageSize = 20;
FpSpread1.ActiveSheetView.RowCount = 20;
FarPoint.Web.Spread.Row myrow;  
int i;
for (i = 0; i < FpSpread1.ActiveSheetView.RowCount; i++)
{
  FpSpread1.ActiveSheetView.SetValue(i, 1, "Row Test");
  myrow = FpSpread1.ActiveSheetView.Rows[i];
  myrow.BackColor = Color.Yellow;
  myrow.ForeColor = Color.Red;
  myrow.Font.Bold = true;
  myrow.Font.Name = "Comic Sans MS";
  myrow.Border = bord;
  myrow.Height = 70;
}      
FpSpread1.ActiveSheetView.ColumnCount = 10
FpSpread1.ActiveSheetView.PageSize = 20
FpSpread1.ActiveSheetView.RowCount = 20
Dim myrow As FarPoint.Web.Spread.Row
Dim i As Integer
For i = 0 To FpSpread1.ActiveSheetView.RowCount - 1
  FpSpread1.ActiveSheetView.SetValue(i, 1, "Row Test")
  myrow = FpSpread1.ActiveSheetView.Rows(i)
  myrow.BackColor = Color.Yellow
  myrow.ForeColor = Color.Red
  myrow.Font.Bold = True
  myrow.Font.Name = "Comic Sans MS"
  myrow.Border = bord
  myrow.Height = 70
Next i
See Also

Reference

Row Class
Row Members
ForeColor Property