Spread ASP.NET 15
FarPoint.Web.Spread Assembly / FarPoint.Web.Spread Namespace / Row Class / ForeColor Property

In This Topic
    ForeColor Property (Row)
    In This Topic
    Gets or sets the default text color for cells in this row.
    Public Property ForeColor As Color
    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

    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.

    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