DragMerged Event

Occurs after user drag merge cells.

Syntax

Javascript (Usage)
Javascript (Specification)

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

Javascript

//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);
});

Reference

Events type