AllowDragDrop Property

Applies To

fpSpread control

Description

Sets or returns whether the user can copy or move a selected block of cells by dragging them to a new location in the same sheet.

Syntax

C++

BOOL CSpreadSheet::GetAllowDragDrop( );
void CSpreadSheet::SetAllowDragDrop(BOOL value);

Visual Basic

[form.]fpSpread.AllowDragDrop[ = boolean%]

Remarks

The default value for the AllowDragDrop property is False.

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

When the AllowDragDrop property is set to True, the user can move or copy the contents of a cell or a block of cells using the drag-and-drop operation.

To move the contents of a cell or cells, the user selects the cell or block of cells, moves the pointer over the edge of the selection until the specified pointer appears, and then drags and drops the selection. To copy the contents of a cell or cells, the user selects the cell or block of cells, moves the pointer over the edge of the selection until the specified pointer appears, presses the Ctrl key, and then drags and drops the selection.

The pointer defaults to an arrow when over the edge of the selection to be moved. To define a different pointer style, set the CursorType property to 8 (Drag Drop Area) then specify the pointer with the CursorStyle property. Use the CursorIcon property to specify an icon as the customized pointer.

When the AllowDragDrop property is set to True and the user performs a drag-and-drop operation and releases the mouse button, the DragDropBlock event occurs.

When the AllowDragDrop property is set to True, if the OperationMode property is set to (2- Row Mode) and the user drags and drops a cell or block of cells, the entire row or rows containing the selected cell or block of cells are dragged and dropped.

Spread Designer

Choose the Book menu, then the Environment menu, select the Environment tab, and then choose the Cell Dragdrop check box in the Book Settings dialog box.

In the Spread Designer the AllowDragDrop and OperationMode properties are temporarily reset in design mode, to assist you in the design process. The AllowDragDrop property is set to True, and the OperationMode property is set to 0 (Normal). When you switch to run-time mode, the sheet behaves according to the settings you have chosen for these properties.

For more information about design mode and run-time mode, see Using Design Versus Run-Time Mode.

Data Type

Integer (Boolean)

DLL Correspondence

SSGetBool (SSB_ALLOWDRAGDROP), SSSetBool (SSB_ALLOWDRAGDROP) functions