Spread 8.0 Documentation
SetOddEvenRowColor Method
Support Options
ActiveX Reference > ActiveX Methods > SetOddEvenRowColor Method

Glossary Item Box

SetOddEvenRowColor Method


See Also    DLL    Example

Applies To

fpSpread control

Description

Sets the background and text colors for odd and even rows.

Syntax

C++

BOOL CSpreadSheet::SetOddEvenRowColor(long clrBackOdd, long clrForeOdd, long clrBackEven, long clrForeEven);

Visual Basic

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

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