Spread.Sheets Documentation
DragDropBlock Event
GC.Spread.Sheets Namespace > Events type : DragDropBlock Event
The sheet that triggered the event.
The sheet's name.
The row index of the top left cell of the source range (range being dragged).
The column index of the top left cell of the source range (range being dragged).
The row index of the top left cell of the destination range (where selection is dropped).
The column index of the bottom right cell of the destination range (where selection is dropped).
The row count of the cell range being dragged.
The column count of the cell range being dragged.
Whether the source range is copied.
Whether the source range is inserted.
The CopyOption value for the drag and drop operation.
A value that indicates whether the operation should be canceled.
Occurs when the user is dragging and dropping a range of cells.
Syntax
var instance; // Type: Events
instance.DragDropBlock = function(sheet,
                                  sheetName,
                                  fromRow,
                                  fromCol,
                                  toRow,
                                  toCol,
                                  rowCount,
                                  colCount,
                                  copy,
                                  insert,
                                  copyOption,
                                  cancel) { };
DragDropBlock = function ( 
   sheet : Worksheet,
   sheetName : string,
   fromRow : number,
   fromCol : number,
   toRow : number,
   toCol : number,
   rowCount : number,
   colCount : number,
   copy : boolean,
   insert : boolean,
   copyOption : CopyToOptions,
   cancel : boolean
) { };

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.
cancel
A value that indicates whether the operation should be canceled.
Example
This example creates log text for the DragDropBlock event.
// Use IE to see the console log text
var activeSheet = spread.getActiveSheet();

activeSheet.bind(GC.Spread.Sheets.Events.DragDropBlock, function (e, args) {
        console.log("From Column:" + args.fromCol);
        console.log("From Row:" + args.fromRow);
        console.log("To Column:" + args.toCol);
        console.log("To Row:" + args.toRow);
    });
See Also

Reference

Events type