回答編集履歴
1
修正
test
CHANGED
|
@@ -8,8 +8,8 @@
|
|
|
8
8
|
|
|
9
9
|
```js
|
|
10
10
|
|
|
11
|
-
sheet.getRange(i+1, 1).setFormula(`=indirect(
|
|
11
|
+
sheet.getRange(i+1, 1).setFormula(`=indirect(address(${rangeList[i].getRow()-1+1},3))`);
|
|
12
12
|
|
|
13
|
-
sheet.getRange(i+1, 2).setValue(`=indirect(
|
|
13
|
+
sheet.getRange(i+1, 2).setValue(`=indirect(address(1,${rangeList[i].getColumn()-1}))`);
|
|
14
14
|
|
|
15
15
|
```
|