DragDropBlock Event

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

Syntax

Javascript (Usage)
Javascript (Specification)

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

DragDropBlock = function ( 
   sheet : Sheet,
   sheetName : string,
   fromRow : number,
   fromCol : number,
   toRow : number,
   toCol : number,
   rowCount : number,
   colCount : number,
   copy : boolean,
   insert : boolean,
   copyOption : CopyToOption,
   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.

Javascript

// Use IE to see the console log text
var activeSheet = spread.getActiveSheet();

activeSheet.bind(GcSpread.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);
    });

Reference

Events type