回答編集履歴
1
あ
test
CHANGED
|
@@ -10,6 +10,8 @@
|
|
|
10
10
|
|
|
11
11
|
const sheet = SpreadsheetApp.getActiveSheet();
|
|
12
12
|
|
|
13
|
+
sheet.getProtections(SpreadsheetApp.ProtectionType.RANGE).forEach(function(e){ e.remove();});
|
|
14
|
+
|
|
13
15
|
const gray = "#999999";
|
|
14
16
|
|
|
15
17
|
const grays = sheet.getDataRange().getBackgrounds().map(function(eo, io){ return eo.map(function(ei, ii){ return {R:io+1,C:ii+1,Col:ei};});}).reduce(function(a,c){ return a.concat(c);},[]).filter(function(e){return e.Col === gray;}) ;
|