回答編集履歴
1
数式を値に変換
test
CHANGED
|
@@ -5,7 +5,11 @@
|
|
|
5
5
|
function copyFormula() {
|
|
6
6
|
const sheet = SpreadsheetApp.getActiveSheet();
|
|
7
7
|
const originalRange = sheet.getRange(1, 3);
|
|
8
|
+
|
|
8
9
|
const newRange = originalRange.offset(1, 0);
|
|
9
10
|
originalRange.copyTo(newRange, SpreadsheetApp.CopyPasteType.PASTE_FORMULA, false);
|
|
11
|
+
|
|
12
|
+
const val = newRange.getDisplayValue();
|
|
13
|
+
newRange.setValue(val);
|
|
10
14
|
}
|
|
11
15
|
```
|