Gets or sets the text color for cells in this alternating row.
Syntax
Visual Basic (Declaration) | |
---|
Public Property ForeColor As Color |
Visual Basic (Usage) | Copy Code |
---|
Dim instance As AlternatingRow
Dim value As Color
instance.ForeColor = value
value = instance.ForeColor |
C# | |
---|
public Color ForeColor {get; set;} |
Property Value
Color object containing the text color for cells in this alternating row
Remarks
Example
This example sets up a two-sheet component. The first sheet has three alternating rows, with the BackColor and ForeColor properties set for each of the rows.
C# | Copy Code |
---|
FpSpread1.Sheets[0].AlternatingRows.Count = 3;
FpSpread1.Sheets[0].Name = "Sheet1";
FpSpread1.Sheets[1].Name = "Sheet2";
FpSpread1.Sheets[0].ColumnCount = 5;
FpSpread1.Sheets[1].ColumnCount = 5;
FpSpread1.Sheets[0].RowCount = 10;
FpSpread1.Sheets[1].RowCount = 10;
FpSpread1.Sheets[0].AlternatingRows[0].BackColor = Color.Red;
FpSpread1.Sheets[0].AlternatingRows[1].BackColor = Color.LightSkyBlue;
FpSpread1.Sheets[0].AlternatingRows[2].BackColor = Color.LightGreen;
FpSpread1.Sheets[1].AlternatingRows[0].BackColor = Color.Red;
FpSpread1.Sheets[1].AlternatingRows[1].BackColor = Color.LightSkyBlue;
FpSpread1.Sheets[0].AlternatingRows[1].ForeColor = Color.Red;
FpSpread1.Sheets[1].AlternatingRows[1].ForeColor = Color.OrangeRed; |
Visual Basic | Copy Code |
---|
FpSpread1.Sheets(0).AlternatingRows.Count = 3
FpSpread1.Sheets(0).Name = "Sheet1"
FpSpread1.Sheets(1).Name = "Sheet2"
FpSpread1.Sheets(0).ColumnCount = 5
FpSpread1.Sheets(1).ColumnCount = 5
FpSpread1.Sheets(0).RowCount = 10
FpSpread1.Sheets(1).RowCount = 10
FpSpread1.Sheets(0).AlternatingRows(0).BackColor = Color.Red
FpSpread1.Sheets(0).AlternatingRows(1).BackColor = Color.LightSkyBlue
FpSpread1.Sheets(0).AlternatingRows(2).BackColor = Color.LightGreen
FpSpread1.Sheets(1).AlternatingRows(0).BackColor = Color.Red
FpSpread1.Sheets(1).AlternatingRows(1).BackColor = Color.LightSkyBlue
FpSpread1.Sheets(0).AlternatingRows(1).ForeColor = Color.Red
FpSpread1.Sheets(1).AlternatingRows(1).ForeColor = Color.OrangeRed |
Requirements
Target Platforms: Windows 7, Windows 8, Windows Vista, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6
See Also