Syntax
| Visual Basic (Declaration) | |
|---|---|
Public Property BackColor As Color | |
| Visual Basic (Usage) |  Copy Code |
|---|---|
Dim instance As Appearance Dim value As Color instance.BackColor = value value = instance.BackColor | |
| C# | |
|---|---|
public Color BackColor {get; set;} | |
Property Value
Color object containing the background colorRemarks
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.
When cells are locked with the Lock and Protect properties, the value of the SheetView.LockBackColor property overrides the value of this property.
If you use this property to retrieve the background color for a range of cells that do not have the same background color, the background color of the active cell is returned.
This property does not change the background color of the drop-down list portion of a combo box cell. The background color of the drop-down list portion of a combo box cell is always white.
If you are working with button cells, use the CellType.ButtonCellType.ButtonColor property to specify the color of the face of the buttons. If you prefer, you can use alternating background colors for the rows in the spreadsheet by using the AlternatingRow.BackColor property for each alternating row.
Specify the text color for the cell by setting the ForeColor property.
Example
| C# | Copy Code |
|---|---|
FarPoint.Win.Spread.Appearance appr = new FarPoint.Win.Spread.Appearance(); FarPoint.Win.Spread.StyleInfo si = new FarPoint.Win.Spread.StyleInfo(); appr.BackColor = Color.Yellow; appr.DrawPrimaryButton = false; appr.DrawSecondaryButton = false; appr.Font = new Font("Comic Sans MS", 10); appr.ForeColor = Color.DarkBlue; appr.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right; appr.LockBackColor = Color.Black; appr.LockForeColor = Color.White; appr.SelectionBackColor = Color.Teal; appr.SelectionForeColor = Color.DarkGreen; appr.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Bottom; si.SetAppearance(appr); fpSpread1.ActiveSheet.SetStyleInfo(0, 0, si); fpSpread1.ActiveSheet.Cells[0, 0].Text = "Apprearance Test"; | |
| Visual Basic | Copy Code |
|---|---|
Dim appr As New FarPoint.Win.Spread.Appearance Dim si As New FarPoint.Win.Spread.StyleInfo appr.BackColor = Color.Yellow appr.DrawPrimaryButton = False appr.DrawSecondaryButton = False appr.Font = New Font("Comic Sans MS", 10) appr.ForeColor = Color.DarkBlue appr.HorizontalAlignment = FarPoint.Win.Spread.CellHorizontalAlignment.Right appr.LockBackColor = Color.Black appr.LockForeColor = Color.White appr.SelectionBackColor = Color.Teal appr.SelectionForeColor = Color.DarkGreen appr.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Bottom si.SetAppearance(appr) FpSpread1.ActiveSheet.SetStyleInfo(0, 0, si) FpSpread1.ActiveSheet.Cells(0, 0).Text = "Apprearance Test" | |
Requirements
Target Platforms: Windows 7, Windows Vista SP1 or later, Windows XP SP3, Windows Server 2008 (Server Core not supported), Windows Server 2008 R2 (Server Core supported with SP1 or later), Windows Server 2003 SP2