Google电子表格 - 删除范围保护时出错 [英] Google spreadsheet - Error when Remove range protection

问题描述

这是我的脚本，但是我无法解决它，因为一些奇怪的原因?? !!!使我抓狂。

Here's my script, but I can't get it to work for some weird reason??!!! Driving me nuts.

function removeThenSetProtection() {
  // Remove all range protections in the spreadsheet that the user has
  //permission to edit.
  var ss = SpreadsheetApp.getActive();
  var protections = ss.getProtections(SpreadsheetApp.ProtectionType.SHEET);

  for (var i = 0; i < protections.length; i++) {
    var protection = protections[i];
    if (protection.canEdit()) {
      protection.remove();
    }
  }
}

推荐答案

更改：

var protections = ss.getProtections(SpreadsheetApp.ProtectionType.RANGE);

收件人：

var protections = ss.getProtections(SpreadsheetApp.ProtectionType.SHEET);

通过这种方式，您可以放心，您将获得所有受保护内容的参考，并且未来的冲突不会发生。

That way, you'll be assured that you are getting a reference to everything that is protected, and future conflicts don't happen.

这篇关于Google电子表格 - 删除范围保护时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！