Spread Windows Forms 7.0 Product Documentation
AllowDragDrop Property
See Also  Example Support Options
FarPoint.Win.Spread Assembly > FarPoint.Win.Spread Namespace > SpreadView Class : AllowDragDrop Property


Glossary Item Box

Gets or sets whether to allow the user to drag and drop a range of cells in the view.

Syntax

Visual Basic (Declaration) 
Public Property AllowDragDrop As Boolean
Visual Basic (Usage)Copy Code
Dim instance As SpreadView
Dim value As Boolean
 
instance.AllowDragDrop = value
 
value = instance.AllowDragDrop
C# 
public bool AllowDragDrop {get; set;}

Property Value

Boolean: true to allow the user to drag and drop data; false otherwise

Remarks

This property determines whether the user can copy or move a selected range of cells by dragging them to a new location in the same spreadsheet. When this property is set to true, the user can move or copy the contents of a cell or a range of cells using the drag-and-drop operation.

To move the contents of a cell or cells, the user selects the cell or range 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 range of cells, moves the pointer over the edge of the selection until the specified pointer appears, presses the Control (Ctrl) key, and then drags and drops the selection.

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

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

The AllowDragDrop property is not supported with grouping.

Example

This example sets the AllowDragDrop property.
C#Copy Code
FarPoint.Win.Spread.SpreadView sv = fpSpread1.GetRootWorkbook();
sv.AllowDragDrop = true;        
VB.NETCopy Code
Dim sv As FarPoint.Win.Spread.SpreadView = FpSpread1.GetRootWorkbook
sv.AllowDragDrop = True

Requirements

Target Platforms: Windows 2000 Professional (SP4), Windows 2000 Server, Windows 2003 Server (SP1), Windows 2008, Windows XP (SP2), Windows Vista, Windows 7, Windows 8

See Also

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