GetOddEvenRowColor, ScriptGetOddEvenRowColor Methods

Applies To

fpSpread control

Description

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

Syntax

C++

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

Visual Basic

fpSpread.GetOddEvenRowColor(clrBackOdd As Long, clrForeOdd As Long, clrBackEven As Long, clrForeEven As Long) As Boolean

Note: The ScriptGetOddEvenRowColor method uses the same syntax except method parameters that are not passed "ByVal" are declared as variants. For more information on Script methods, see Scripting Environment Usage.

Parameters

The following parameters are available:

Parameter	Description
lpclrBackOdd	Returns the background color of odd rows
lpclrForeOdd	Returns the text color of odd rows
lpclrBackEven	Returns the background color of even rows
lpclrForeEven	Returns the text color of even rows

Remarks

Call this method to return the different background and text colors displayed 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.

Call the SetOddEvenRowColor method to set the background and text colors for odd and even rows.

Note: Call this method if you use the Spread control in a scripting environment (for example, Microsoft's Visual InterDev or Internet Explorer) or a non-scripting environment. However, if you want to use the Spread control in a scripting environment and you want to change any parameter that is not passed "ByVal", you must set the ScriptEnhanced property to True and call the ScriptGetOddEvenRowColor method. ScriptGetOddEvenRowColor method parameters that are not passed "ByVal" are declared as variants.

Return Type

True if successful; otherwise, False.

DLL Correspondence

SSGetOddEvenRowColor function