Spread 8.0 Documentation
GetOddEvenRowColor, ScriptGetOddEvenRowColor Methods
Support Options
ActiveX Reference > ActiveX Methods > GetOddEvenRowColor, ScriptGetOddEvenRowColor Methods

Glossary Item Box

GetOddEvenRowColor, ScriptGetOddEvenRowColor Methods


See Also    DLL

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.

See Also

Setting Odd and Even Row Colors

BackColor, ForeColor, ScriptEnhanced, Sheet properties

SetOddEvenRowColor method

DLL Correspondence

SSGetOddEvenRowColor function

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