Spread 8.0 Documentation
BackColorStyle Property
Support Options
ActiveX Reference > ActiveX Properties > BackColorStyle Property

Glossary Item Box

BackColorStyle Property


See Also    DLL    Example

Applies To

fpSpread control

Description

Sets or returns whether the background colors of cells overlap the grid lines.

Syntax

C++

long CSpreadSheet::GetBackColorStyle( );
void CSpreadSheet::SetBackColorStyle(long value);

Visual Basic

[form.]fpSpread.BackColorStyle[ = setting%]

Remarks

The following settings are available:

Setting Description Constants
0 - Over Grid (Default) Hides the right and bottom sides of the cells' grid lines under the background color BackColorStyleOverGrid
1 - Under Grid Displays complete grid lines BackColorStyleUnderGrid
2 - Over
Horizontal
Grid Only
Hides the horizontal grid lines under the background color BackColorStyleOverHorzGridOnly
3 - Over
Vertical
Grid Only
Hides the vertical grid lines under the background color BackColorStyleOverVertGridOnly

This setting is applied to the entire workbook, including all sheets in the control.

By default, the background color of a cell overlaps (hides) the right and bottom sides of the cell's grid lines. Use the BackColorStyle property to display the right grid line, the bottom grid line, or both grid lines over the background color.

Spread Designer

Choose the Book menu, then the Display menu, select the Display tab, and then choose an option box in the Back Color Displays group box in the Book Settings dialog box.

Data Type

Integer (Enumerated)

See Also

Customizing Grid Lines

BackColor property

DLL Correspondence

SSGetBackColorStyle, SSSetBackColorStyle functions

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