Spread for ASP.NET 8.0 Product Documentation
ForeColor Property (Row)
Example 


Gets or sets the default text color for cells in this row.
Syntax
'Declaration
 
Public Property ForeColor As Color
'Usage
 
Dim instance As Row
Dim value As Color
 
instance.ForeColor = value
 
value = instance.ForeColor
public Color ForeColor {get; set;}

Property Value

Color object that contains the text 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 text color.

Specify the background color for the cell by setting the BackColor 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
Requirements

Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

Row Class
Row Members
BackColor Property

 

 


Copyright © GrapeCity, inc. All rights reserved.