SetOddEvenRowColor Method
Applies To
fpSpread control
Description
Sets the background and text colors for odd and even rows.
Syntax
BOOL CSpreadSheet::SetOddEvenRowColor(long clrBackOdd, long clrForeOdd, long clrBackEven, long clrForeEven);
fpSpread.SetOddEvenRowColor(ByVal clrBackOdd As Long, ByVal clrForeOdd As Long, ByVal clrBackEven As Long, ByVal clrForeEven As Long) As Boolean
Parameters
The following parameters are available:
| Parameter | Description |
|---|---|
| clrBackOdd | Background color of odd rows |
| clrForeOdd | Text color of odd rows |
| clrBackEven | Background color of even rows |
| clrForeEven | Text color of even rows |
Remarks
Call this method to specify different background and text colors to display in odd and even rows.
This method is called for the current sheet setting unless you first set the Sheet property to specify the sheet with which you want to work.
If you set the BackColor or ForeColor property for a cell, column, or row, the cell, column, or row setting will override the odd or even row colors set using this method. For more information, see Precedence of Settings.
Spread Designer
Choose the Sheet menu, then the Sheet Colors menu, select the Sheet Colors tab, and then select an item from the Property drop-down list box in the Sheet Settings dialog box.
| Parameter | Items on Colors tab |
|---|---|
| clrBackOdd | Select OddRowBackColor from the Property drop-down list box |
| clrForeOdd | Select OddRowForeColor from the Property drop-down list box |
| clrBackEven | Select EvenRowBackColor from the Property drop-down list box |
| clrForeEven | Select EvenRowForeColor from the Property drop-down list box |
Return Type
True if successful; otherwise, False.
See Also
Setting Odd and Even Row Colors
BackColor, ForeColor, Sheet properties
GetOddEvenRowColor method
DLL Correspondence
SSSetOddEvenRowColor method