GridColor Property

---

See Also    DLL    Example

Applies To

fpSpread control

Description

Sets or returns the color of the grid lines.

Syntax

unsigned long CSpreadSheet::GetGridColor( );
void CSpreadSheet::SetGridColor(unsigned long value);

[form.]fpSpread.GridColor[ = color]

Remarks

The default value for the GridColor property is &H00C0C0C0& (light gray).

This property does not have an effect unless either or both of the GridShowHoriz and the GridShowVert properties are set to True.

By default, the background color of cells overlaps the bottom and right sides of the surrounding grid lines, hiding those portions of the grid lines from view if the background color is set to a color other than white. To display all sides of the grid lines, set the BackColorStyle property to 1 (Under Grid).

This setting is applied to the current sheet setting unless you first set the Sheet property to specify the sheet for which you are setting the property.

Specify whether the sheet displays horizontal grid lines, vertical grid lines, or both, using the GridShowHoriz and GridShowVert properties. Specify whether the grid lines are solid or dotted using the GridSolid property.

Spread Designer

Choose the Sheet menu, then the Sheet Colors menu, select the Sheet Colors tab, and then choose GridColor from the Property drop-down list box in the Sheet Settings dialog box.

Data Type

Color

See Also

Customizing Grid Lines

BackColorStyle, GridShowHoriz, GridShowVert, GridSolid, Sheet properties

DLL Correspondence

SSGetGridColor, SSSetGridColor functions