回答編集履歴
1
test
CHANGED
|
@@ -26,15 +26,13 @@
|
|
|
26
26
|
|
|
27
27
|
var values = range.getValues();
|
|
28
28
|
var formulas = range.getFormulas();
|
|
29
|
+
values.map((r, i) => r.map((c, j) =>
|
|
30
|
+
bgColors[i][j] === "#ffff00" ? values[i][j] = '' :
|
|
29
|
-
|
|
31
|
+
formulas[i][j] !== '' ? values[i][j] = formulas[i][j] :
|
|
32
|
+
0
|
|
33
|
+
));
|
|
30
34
|
|
|
31
|
-
for (var i in bgColors) {
|
|
32
|
-
for (var j in bgColors[i]) {
|
|
33
|
-
if (bgColors[i][j] === "#ffff00")
|
|
34
|
-
formulas[i][j] = '';
|
|
35
|
-
}
|
|
36
|
-
}
|
|
37
|
-
range.setValues(
|
|
35
|
+
range.setValues(values);
|
|
38
36
|
}
|
|
39
37
|
```
|
|
40
38
|
|