SSGetColHeaderDisplay, SSSetColHeaderDisplay Functions

Applies To

fpSpread DLL control

Description

Set or return whether the column header displays letters or numbers or is blank.

Syntax

WORD SSGetColHeaderDisplay(HWND hWnd);

WORD SSSetColHeaderDisplay(HWND hWnd, WORD wDisplay);

C++

WORD TSpread::GetColHeaderDisplay( );

WORD TSpread::SetColHeaderDisplay(WORD wDisplay);

Parameters

The SSGetColHeaderDisplay function has the following parameter:

Parameter	Description
hWnd	Window handle of the fpSpread control

The SSSetColHeaderDisplay function has the following parameters:

Parameter	Description
hWnd	Window handle of the fpSpread control
wDisplay	Numbering style Use one of the following values:
	Constant	Description
	SS_HEADERDISPLAY_BLANK	Displays blanks
	SS_HEADERDISPLAY_NUMBERS	Displays the column headers as numbers
	SS_HEADERDISPLAY_LETTERS	Displays the column headers as letters

Remarks

This function is applied to the current sheet setting unless you first call the SSSetSheet function to specify the sheet for which you are calling this function.

By default, column headers are displayed as letters; however, the headers can be blank or display numbers. Call the SSSetColHeaderDisplay function to specify the numbering style of the column headers.

Notes:

Use the SSSetColHeaderDisplay function with column header cells that do not contain data. If you place data into a column header cell using the SSSetData or SSSetValue functions, the value of the SSSetData or SSSetValue function overrides any previously applied SSSetColHeaderDisplay function setting.
The SSGetData and SSGetValue functions do not return the text in a column or row header cell unless the cell contains data (custom text). The functions do not return the auto text in the header cells.

If your control displays multiple column header rows, call the SSSetColHeadersAutoTextIndex function to specify which column header row contains the auto text.

This function does not have an effect unless the SSB_SHOWCOLHEADERS boolean for the SSSetBool function is set to TRUE and the column header row is not hidden. If the control displays multiple headers, this function does not have an effect if the row displaying the auto text (specified by calling the SSSetColHeadersAutoTextIndex function) is hidden.

Use the SSSetRowHeaderDisplay function to specify the numbering style of the row headers.

Return Value

Previous value (refer to the wDisplay parameter for an explanation of the available return values).

ActiveX Correspondence

ColHeadersAutoText property