SpreadJS 13
GC.Spread.Sheets Namespace / Events type / DragMerged Event
The sheet that triggered the event.
The sheet's name.
The range that will be merged.
In This Topic
    DragMerged Event
    In This Topic
    Occurs after user drag merge cells.
    Syntax
    var instance; // Type: Events
    instance.DragMerged = function(sheet, sheetName, mergeRange) { };
    DragMerged = function ( 
       sheet : Worksheet,
       sheetName : string,
       mergeRange : Range
    ) { };

    Parameters

    sheet
    The sheet that triggered the event.
    sheetName
    The sheet's name.
    mergeRange
    The range that will be merged.
    Example
    //This example returns the row index.
    // Press Ctrl key to merge
    $(document).keydown(function (e) {
         if (e.keyCode === 17) {
            spread.options.allowUserDragMerge = true;
         }
    });
    $(document).keyup(function (e) {
         if (e.keyCode === 17) {
            spread.options.allowUserDragMerge = false;
         }
    });
    activeSheet.bind(GC.Spread.Sheets.Events.DragMerging, function (e, data) {
         var mergeRange = data.mergeRange;
         alert(mergeRange.row);
    });
    activeSheet.bind(GC.Spread.Sheets.Events.DragMerged, function (e, data) {
         var mergeRange = data.mergeRange;
         alert(mergeRange.row);
    });
    See Also

    Reference

    Events type