Spread 8.0 Documentation
SSGetSelBlockOptions, SSSetSelBlockOptions Functions
Support Options
DLL Reference > DLL Functions > SSGetSelBlockOptions, SSSetSelBlockOptions Functions

Glossary Item Box

SSGetSelBlockOptions, SSSetSelBlockOptions Functions


See Also    ActiveX

Applies To

fpSpread DLL control

Description

Set or return whether the user can select columns, rows, blocks of cells, all cells, or any combination of these.

Syntax

C

WORD SSGetSelBlockOptions(HWND hWnd);

WORD SSSetSelBlockOptions(HWND hWnd, WORD wOption);

C++

WORD TSpread::GetSelBlockOptions( );

WORD TSpread::SetSelBlockOptions(WORD wOption);

Parameters

The SSGetSelBlockOptions function has the following parameter:

Parameter Description
hWnd Window handle of the fpSpread control

The SSSetSelBlockOptions function has the following parameters:

Parameter Description
hWnd Window handle of the fpSpread control
wOption Combine any of the following values with the (|) OR operator:
Constant Description
SS_SELBLOCK_COLS User can select an entire column by clicking the column header
SS_SELBLOCK_ROWS User can select an entire row by clicking the row header
SS_SELBLOCK_BLOCKS User can select a block of cells by using the mouse or the keyboard
SS_SELBLOCK_ALL User can select the entire sheet by clicking the upper-left cell

Remarks

This function is applied to the entire workbook, including all sheets in the control.

These functions limit the user to selecting either entire columns, entire rows, blocks of cells, the entire sheet, or any combination of the above.

Note: Setting the SSSetBool function SSB_EDITMODEPERMANENT boolean to TRUE automatically sets the SSSetSelBlockOptions function to 0. If you then set the SSSetBool function SSB_EDITMODEPERMANENT boolean to FALSE, you must reset the SSSetSelBlockOptions function to its original setting.

Return Value

SSGetSelBlockOptions: Current selection options (any combination of the values for the SSSetSelBlockOptions wOption parameter).
SSSetSelBlockOptions: Previous selection options.

See Also

Specifying Which Elements Users Can Select

ActiveX Correspondence

SelectBlockOptions property

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