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

WORD SSGetSelBlockOptions(HWND hWnd);

WORD SSSetSelBlockOptions(HWND hWnd, WORD wOption);

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