Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

options.protectionOptions 属性可以用来指定你想让用户编辑哪些区域。可控制的属性包括重设大小,筛选等等。

示例代码
以下代码会解锁某些单元格。

...

Code Block
languagejs
titleJavaScript

...

Copy Code

heet.getCell(1,1, GC.Spread.Sheets.SheetArea.viewport).locked(false);

...


sheet.setValue(1,1,"unLocked");

...


sheet.getRange(-1,3, -1, 1).locked(false);

...


sheet.getRange(5, -1, 1, -1).locked(false);

...


sheet.options.isProtected = true;

...