SelectBlockOptions Property

Applies To

fpSpread control

Description

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

Syntax

C++

long CSpreadSheet::GetSelectBlockOptions( );
void CSpreadSheet::SetSelectBlockOptions(long value);

Visual Basic

[form.]fpSpread.SelectBlockOptions[ = value&]

Remarks

The following values are available. Note that you can combine values 1, 2, 4, and 8 using the Or operator to limit user selections within the sheet. The default value is 15 (combination of all values), which lets the user select columns, rows, blocks of cells, or the entire sheet. Setting the SelectBlockOptions property to 0 prevents the user from making selections within the sheet.

Value	Description	Constant
1	Lets the user select columns	SelectBlockOptionsColumns
2	Lets the user select rows	SelectBlockOptionsRows
4	Lets the user select blocks of cells	SelectBlockOptionsBlocks
8	Lets the user select the entire sheet by clicking the upper-left cell	SelectBlockOptionsAll

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

Note: Setting the EditModePermanent property to True automatically sets the SelectBlockOptions property to 0. If you then set the EditModePermanent property to False, you must reset the SelectBlockOptions property to its original setting.

Spread Designer

Choose the Book menu, then the Block Mode menu, select the Block Mode tab, and then choose a check box in the User Can Select group box in the Book Settings dialog box.

In the Spread Designer, the SelectBlockOptions property is temporarily reset to Columns, Rows, Blocks, and All 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

DLL Correspondence

SSGetSelBlockOptions, SSSetSelBlockOptions functions