DragDropBlockCompleted Event

Occurs when the user completes dragging and dropping a range of cells.

Syntax

Javascript (Usage)
Javascript (Specification)

var instance; // Type: Events
instance.DragDropBlockCompleted = function(sheet,
                                           sheetName,
                                           fromRow,
                                           fromCol,
                                           toRow,
                                           toCol,
                                           rowCount,
                                           colCount,
                                           copy,
                                           insert,
                                           copyOption) { };

DragDropBlockCompleted = function ( 
   sheet : Worksheet,
   sheetName : string,
   fromRow : number,
   fromCol : number,
   toRow : number,
   toCol : number,
   rowCount : number,
   colCount : number,
   copy : boolean,
   insert : boolean,
   copyOption : CopyToOptions
) { };

Parameters

sheet: The sheet that triggered the event.
sheetName: The sheet's name.
fromRow: The row index of the top left cell of the source range (range being dragged).
fromCol: The column index of the top left cell of the source range (range being dragged).
toRow: The row index of the top left cell of the destination range (where selection is dropped).
toCol: The column index of the bottom right cell of the destination range (where selection is dropped).
rowCount: The row count of the cell range being dragged.
colCount: The column count of the cell range being dragged.
copy: Whether the source range is copied.
insert: Whether the source range is inserted.
copyOption: The CopyOption value for the drag and drop operation.

Example

This example uses the DragDropBlockCompleted event.

Javascript

activeSheet.bind(GC.Spread.Sheets.Events.DragDropBlockCompleted, function (e, args) {    
        alert("From Column (" + args.fromCol + ")");
});

Reference

Events type