Spread Windows Forms 6.0 Product Documentation
ForeColor Property
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > Appearance Class : ForeColor Property


Glossary Item Box

Gets or sets the text color of an object.

Syntax

Visual Basic (Declaration) 
Public Property ForeColor As Color
Visual Basic (Usage)Copy Code
Dim instance As Appearance
Dim value As Color
 
instance.ForeColor = value
 
value = instance.ForeColor
C# 
public Color ForeColor {get; set;}

Property Value

Color object containing the text color

Remarks

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.

Example

This example illustrates the use of this property. An Appearance object is used to set up the behavior for a StyleInfo object.
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 BasicCopy 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

See Also

© 2002-2012 ComponentOne, a division of GrapeCity. All Rights Reserved.