BackColorStyle Property

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)

DLL Correspondence

SSGetBackColorStyle, SSSetBackColorStyle functions