本帖最后由 sanyue 于 2023-11-10 14:39 编辑
设定getRange().locked(true)页面要么要等很久很久,要么就页面卡死
- spread.suspendPaint();
- for (let i = 0; i < sheetCount; i++) {
- const sheet = spread.getSheet(i);
- sheet.options.isProtected = true;
- sheet.options.protectionOptions = {
- allowFilter: true,
- };
- //主要是这一行,删掉就快了
- sheet.getRange(0, 0, sheet.getRowCount(), sheet.getColumnCount()).locked(true);
- }
- spread.resumePaint();
复制代码
|
|