ColHeadersShow Property

Applies To

fpSpread control

Description

Sets or returns whether the sheet displays a column header row.

Syntax

C++

BOOL CSpreadSheet::GetColHeadersShow( );
void CSpreadSheet::SetColHeadersShow(BOOL value);

Visual Basic

[form.]fpSpread.ColHeadersShow[ = boolean%]

Remarks

The default value for the ColHeadersShow property is True.

When the ColHeadersShow property is set to True, the sheet displays column headers. When the ColHeadersShow property is set to False, the sheet does not display column headers, even if you have specified to display multiple header rows.

If your sheet displays multiple header rows and you do not want to display one of the header rows, set the RowHidden property to True to hide a specified header row.

If you decide to have the sheet not display column headers, you can use the RowsFrozen property to create nonscrolling rows that act similarly to column headers.

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.

You can specify whether the sheet displays row headers using the RowHeadersShow property.

Spread Designer

Choose the Sheet menu, then the Headers menu, and then the General menu, select the Columns tab, and then select the Display Headers check box in the Header Settings dialog box.

In the Spread Designer the ColHeadersShow property is temporarily reset to True when in design mode to assist you in the design process. When you switch to run-time mode, the sheet behaves according to the setting you have chosen for this property.

For more information about design mode and run-time mode, see Using Design Versus Run-Time Mode.

Data Type

Integer (Boolean)

DLL Correspondence

SSGetBool (SSB_SHOWCOLHEADERS), SSSetBool (SSB_SHOWCOLHEADERS) functions