如题:
刚开始我是替换为0的
sheet.addKeyMap(88, false, false, false, false, function () {
var selections = sheet.getSelections();
for (var i = 0; i < selections.length; i++) {
var range = selections[i];
var rowlen = (range.rowCount - 0) + (range.row - 0);
var collen = (range.colCount - 0) + (range.col - 0);
for (var row = range.row; row < rowlen; row++) {
for (var col = range.col; col < collen; col++) {
if (sheet.getActualStyle(row, col).locked == false) {
//只修改允许编辑的数据
sheet.setValue(row, col, 0);//设置为0
sheet.getCell(row, col).foreColor("Blue");//标记为修改
}
}
}
}
});
but ,没起作用,剪切,求指导,或者禁用按钮的方法。
|
|