Spread ASP.NET 6.0 Product Documentation
BackColor Property
See Also  Example Send Feedback
FarPoint.Web.Spread Assembly > FarPoint.Web.Spread Namespace > Row Class : BackColor Property


Glossary Item Box

Gets or sets the background color for cells in this row.

Syntax

Visual Basic (Declaration) 
Public Property BackColor As Color
Visual Basic (Usage)Copy Code
Dim instance As Row
Dim value As Color
 
instance.BackColor = value
 
value = instance.BackColor
C# 
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.
C#Copy Code
    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;
    }      
Visual BasicCopy Code
    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 98, Windows NT 4.0, Windows Millennium Edition, Windows 2000, Windows XP Home Edition, Windows XP Professional, Windows Server 2003 family, Windows Vista, Windows Server 2008 family

See Also

© 2002-2012 GrapeCity, Inc. All Rights Reserved.