sheet.bind(GC.Spread.Sheets.Events.DragFillBlock, function (sender, args) { //黑十字拖拽复制过程绑定处理事件
args.cancel= false;
const sheet = args.sheet,
fillRange = args.fillRange,
sheetIndex = sheetNameList.indexOf(args.sheetName); //获取当前编辑的sheet下标
let copyValue = ""; //被复制的值
if( args.fillDirection==1 ){ //向右拖拽复制
copyValue = sheet.getValue(fillRange.row,fillRange.col-1);
for(let i = 1;i<=fillRange.colCount;i++){
const col = fillRange.col+i-1, //当前单元格列数
tag = sheet.getTag( fillRange.row,col); //当前单元格tag标签
dropInfoArray.push({ //向本地数组中添加拖拽复制的单元格行列单元格信息
row:fillRange.row,
col,
tag,
val:copyValue
})
}
}
console.log(11,222)
});
sheet.bind(GC.Spread.Sheets.Events.DragFillBlockCompleted, function (e, info) { //
const sheet = args.sheet,
sheetIndex = sheetNameList.indexOf(args.sheetName); //获取当前编辑的sheet下标
debugger;
dropInfoArray.forEach(v=>{
console.log( v,'v' );
sheet.setTag(v.row,v.col,v.tag);
debugger;
saveEditData(v.tag,sheetIndex,v.val);
})
})
绑定两个事件,第一个拖拽触发,第二个根本就不触发 |