Spread Windows Forms 9.0 Product Documentation
ColumnDragMove Event
Example 


Occurs when AllowColumnMove is true and the user drags to move a column.
Syntax
'Declaration
 
Public Event ColumnDragMove As DragMoveEventHandler
'Usage
 
Dim instance As FpSpread
Dim handler As DragMoveEventHandler
 
AddHandler instance.ColumnDragMove, handler
public event DragMoveEventHandler ColumnDragMove
Event Data

The event handler receives an argument of type DragMoveEventArgs containing data related to this event. The following DragMoveEventArgs properties provide information specific to this event.

PropertyDescription
CancelGets or sets whether to cancel the drag operation.  
CountGets the number of columns or rows to move.  
IndexGets the column or row index of the drag.  
MoveContentGets or sets whether the move operation moves the contents of the rows or columns (and rows or columns in between) without changing the index mapping.  
ViewGets the view in which the columns or row are being dragged.  
Remarks

This event is raised by the OnColumnDragMove method when the user drags to move a column, which can only happen when the AllowColumnMove property is true. The MoveContent property defaults to false when the control is bound; true otherwise.

For more details on the individual event arguments, refer to DragMoveEventArgs members.

Example
This example does not allow the first four columns to be moved.
fpSpread1.AllowColumnMove = true;

fpSpread1.ColumnDragMove +=new FarPoint.Win.Spread.DragMoveEventHandler(fpSpread1ColumnDragMove);

private void fpSpread1ColumnDragMove(object sender, FarPoint.Win.Spread.DragMoveEventArgs e)
{
      if (e.Index < 3)
      { 
            e.Cancel = true;
      }
}
FpSpread1.AllowColumnMove = True

Dim eh As FarPoint.Win.Spread.DragMoveEventHandler = AddressOf Fpspread1ColumnDragMove
AddHandler FpSpread1.ColumnDragMove, eh

Private Sub Fpspread1ColumnDragMove(ByVal sender As Object, ByVal e As FarPoint.Win.Spread.DragMoveEventArgs) Handles FpSpread1.ColumnDragMove
      If e.Index < 3 Then
            e.Cancel = True
End Sub
Requirements

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

See Also

Reference

FpSpread Class
FpSpread Members
DragMoveEventArgs Class

 

 


Copyright © GrapeCity, inc. All rights reserved.