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
long CSpreadSheet::GetSelectBlockOptions( );
void CSpreadSheet::SetSelectBlockOptions(long value);
[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
See Also
Using Design Versus Run-Time Mode
Specifying Which Elements Users Can Select
EditModePermanent property
BlockSelected, SelChange events
DLL Correspondence
SSGetSelBlockOptions, SSSetSelBlockOptions functions