sheet.getProtections 不再有效?

本文介绍了sheet.getProtections 不再有效?的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我有一个脚本可以自动保护我的工作表中过去的日期范围.

I have a script that automatically protects a range of past Dates in my Sheet.

我使用标准的sheet.getProtections(SpreadsheetApp.ProtectionType.RANGE);

它运行了好几个月，但从昨天开始就没有用了.

It worked fine for several months but it has not worked since yesterday.

是否对实现有任何修改?

Is there any modifications on the implementations ?

谢谢

附:工作表对象在我的测试中得到了很好的返回

PS :the sheet object is well returned in my tests

var sheet = SpreadsheetApp.getActiveSpreadsheet().getSheetByName("TRAVAUX");
var debug = sheet.getName();
var protections = sheet.getProtections(SpreadsheetApp.ProtectionType.RANGE);

运行该函数时的错误信息

Error message when running the function

服务错误:电子表格

似乎有几个开发者遇到了这个问题，可能是 bug 或临时问题.

该问题已在公共问题跟踪器上报告.给它打个星"表示你也受到影响.

There seem to be several developers with this problem, it might be a bug or a temporary problem.

The issue has been reported on Public Issue Tracker. Give it a "star" to indicate that you are also affected.

这篇关于sheet.getProtections 不再有效?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！

Sheet