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:表格对象在我的测试中很好地返回了

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

似乎有多个开发人员存在此问题，这可能是错误或暂时性问题.

已在公共问题跟踪器中报告了该问题.给它加一个星号"，表示您也受到了影响.

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