var w = {
"Welcome": {
title: "Welcome",
text: "Welcome",
type: "checkbox",
commandName: "Welcome",
execute: async (context, propertyName, fontItalicChecked) => {
debugger
var spread = context.getWorkbook();
var sheet = spread.getActiveSheet();
console.log(sheet.getSelections())
let selections = sheet.getSelections()[0];
for (let i = selections.col; i < selections.colCount + selections.col; i++) {
for (let j = selections.row; j < selections.rowCount + selections.row; j++) {
if (sheet.getCell(i, j).locked()) {
sheet.getCell(i, j).locked(false);
} else {
sheet.getCell(i, j).locked(true);
}
}
}
},
getState: (context) => {
let sheet = context.Spread.getActiveSheet(); //设置 checkBox 初始状态 //return !sheet.isPrintLineVisible(); //初始为选中状态
// console.log(sheet);
// console.log(context);
// console.log(
// sheet
// .getCell(sheet.getActiveRowIndex(), sheet.getActiveColumnIndex())
// .locked()
// );
return context.Spread.getActiveSheet()
.getCell(sheet.getActiveRowIndex(), sheet.getActiveColumnIndex())
.locked(); //初始为未选中状态
},
}
}
改成我这样就复现问题了,这种怎么解决,只有A1能切换 |