“copyTo()”可以复制带有值、公式和格式的单元格。https://developers.google.com/apps-script/reference/spreadsheet/sheet#copyTo(Spreadsheet) https://developers.google.com/apps-script/reference/spreadsheet/sheet#copyTo(Spreadsheet)
示例脚本如下。
Script :
var range = ss.getRange('a1:a8');
var values = range.getValues();
var formulas = range.getFormulas();
var destrange = ss.getRange('b1:b8');
range.copyTo(destrange);
var destvalues = destrange.getValues();
var destformulas = destrange.getFormulas();
values :
[[1.0], [5.0], [3.0], [9.0], [1.0], [2.0], [3.0], [24.0]]
公式:
[[], [], [], [=sum(A1:A3)], [], [], [], [=sum(A1:A7)]]
目标值:
[[1.0], [5.0], [3.0], [9.0], [1.0], [2.0], [3.0], [24.0]]
目标公式:
[[], [], [], [=sum(B1:B3)], [], [], [], [=sum(B1:B7)]]
如果这对您有帮助,我很高兴。