FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > Appearance Class : ForeColor Property |
'Declaration Public Property ForeColor As Color
'Usage Dim instance As Appearance Dim value As Color instance.ForeColor = value value = instance.ForeColor
public Color ForeColor {get; set;}
The setting for this property can be overridden if a named style is assigned to the cell using the the StyleName property, and that named style sets the text color.
When cells are locked with the Lock and Protect properties, the value of the SheetView.LockForeColor property overrides the value of this property.
If you use this property to retrieve the text color for a range of cells that do not have the same text color, the text color for the active cell is returned.
If you are working with button cells, use the CellType.ButtonCellType.ButtonColor property to specify the color of the text in the buttons.
Specify the background color for the cell by setting the BackColor property.
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.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Bottom; si.SetAppearance(appr); fpSpread1.ActiveSheet.SetStyleInfo(0, 0, si); fpSpread1.ActiveSheet.Cells[0, 0].Text = "Apprearance Test";
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.VerticalAlignment = FarPoint.Win.Spread.CellVerticalAlignment.Bottom si.SetAppearance(appr) FpSpread1.ActiveSheet.SetStyleInfo(0, 0, si) FpSpread1.ActiveSheet.Cells(0, 0).Text = "Apprearance Test"
Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8