I have a script that automatically protects a range of past Dates in my Sheet.
I use the standard 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 ?
Thank you
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
Service error: Spreadsheets
//To get last row of the sheet. var LastRowOfSheet = SpreadsheetApp. getActive(). getActiveSheet().
Click the name of the script in the left-hand box alongside the script text in the text editor to highlight it. Select the "File" menu and then click "Delete."
getActiveSpreadsheet()Returns the currently active spreadsheet, or null if there is none. Functions that are run in the context of a spreadsheet can get a reference to the corresponding Spreadsheet object by calling this function.
To rename a sheet in a Google Sheets spreadsheet, we will use the setName() method of the Sheet object. The function renameSheet() accepts two parameters: (1) the current name of the sheet and (2) its new name.
The issue has been reported on Public Issue Tracker. Give it a "star" to indicate that you are also affected.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With