SpreadJS 13
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.
In This Topic
    DragDropBlock Event
    In This Topic
    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