Copy with SHEET Protections скачать в хорошем качестве

Copy with SHEET Protections

Make a copy of a sheet with sheet-level protections in the same spreadsheet. This does NOT affect the behavior of any built-in tools or menus and only works when the copy is triggered by the script Sheet (make a copy from the File menu) https://docs.google.com/spreadsheets/... Script (the array.map version is in the script on the file but arrow functions cannot be in a YouTube description): function copyWithProtections(){ const sh = SpreadsheetApp.getActiveSpreadsheet(); const ss = sh.getSheetByName("Template"); const prot = ss.getProtections(SpreadsheetApp.ProtectionType.SHEET) let nSheet = ss.copyTo(sh).setName(sh.getNumSheets()-1); let p = nSheet.protect(); let unProtect = prot[0].getUnprotectedRanges(); let ranges = []; for (let i in unProtect){ ranges.push(nSheet.getRange(unProtect[i].getA1Notation())); } p.setUnprotectedRanges(ranges); } I use AppsScript Color for the dark theme, OBS Studio to record, and a Blue Yeti microphone Connect with me: • spencer.farris@gmail.com • spencerfarris.me • www.linkedin.com/in/spencer-farris/ • Twitter/X @FarrisSpencer • Google Product Expert support.google.com/docs/profile/12305 I also take on consultations, custom projects, and individual trainings as needed Donate on Paypal: spencer.farris@gmail.com