Spread 8.0 Documentation
SelectBlockOptions Property
Support Options
ActiveX Reference > ActiveX Properties > SelectBlockOptions Property

Glossary Item Box

SelectBlockOptions Property


See Also    DLL    Example

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

See Also

Using Design Versus Run-Time Mode
Specifying Which Elements Users Can Select

EditModePermanent property

BlockSelected, SelChange events

DLL Correspondence

SSGetSelBlockOptions, SSSetSelBlockOptions functions

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