Spread 8.0 Documentation
SSGetColHeaderDisplay, SSSetColHeaderDisplay Functions
Support Options
DLL Reference > DLL Functions > SSGetColHeaderDisplay, SSSetColHeaderDisplay Functions

Glossary Item Box

SSGetColHeaderDisplay, SSSetColHeaderDisplay Functions


See Also    ActiveX

Applies To

fpSpread DLL control

Description

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

Syntax

C

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).

See Also

Specifying Header Content Type

SSGetColHeadersAutoTextIndex, SSGetRowHeaderDisplay, SSSetColHeadersAutoTextIndex, SSSetRowHeaderDisplay, SSSetSheet functions

ActiveX Correspondence

ColHeadersAutoText property

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