单元格锁定问题

moon0126

通过这个贴子来锁定某些单元格不可编缉发现整个sheet都被锁了。
https://gcdn.grapecity.com.cn/forum.php?mod=viewthread&tid=98263&extra=

let sheet = spread.getActiveSheet()
let defaultStyle = sheet.getDefaultStyle()
defaultStyle.locked = false
sheet.setDefaultStyle(defaultStyle)
let range = sheet.getRange(0,0,5,5)
range.backColor('#9cf')
range.locked(true)
sheet.options.isProtected = true

求教：怎么才能只锁定某些单元格

moon0126 · moon0126

let option = {
         allowSelectLockedCells: true,
         allowSelectUnlockedCells: true,
         allowFilter: true,
         allowSort: true,
         allowResizeRows: true,
         allowResizeColumns: true,
         allowEditObjects: true,
         allowDragInsertRows: true,
         allowDragInsertColumns: true,
         allowInsertRows: true,
         allowInsertColumns: true,
         allowDeleteRows: true,
         allowDeleteColumns: true,
      };
必须设置options