回答編集履歴
1
offsetに変更
answer
CHANGED
@@ -28,13 +28,13 @@
|
|
28
28
|
if (!checkTarget(e)) return;
|
29
29
|
var pref = getPref();
|
30
30
|
if(e.value === undefined) {
|
31
|
-
e.range.
|
31
|
+
e.range.offset(0, 1).clear().clearDataValidations();
|
32
32
|
} else {
|
33
33
|
var rule = SpreadsheetApp.newDataValidation()
|
34
34
|
.requireValueInList(pref[e.value])
|
35
35
|
.setAllowInvalid(false)
|
36
36
|
.build();
|
37
|
-
e.range.
|
37
|
+
e.range.offset(0, 1).clear().setDataValidation(rule);
|
38
38
|
}
|
39
39
|
}
|
40
40
|
```
|