我需要修改下面的脚本,只将值复制到另一张工作表中,而不是公式。谢谢!
function onEdit(event) {
// assumes source data in sheet named ClientList
// target sheet of move to named CLOSED
// test column with C is col 7 or G
var ss = SpreadsheetApp.getActiveSpreadsheet();
var s = event.source.getActiveSheet();
var r = event.source.getActiveRange();
if(s.getName() == "ClientList" && r.getColumn() == 7 && r.getDisplayValue() == "C1" || r.getDisplayValue() == "C2" || r.getDisplayValue() == "C3") {
var row = r.getRow();
var numColumns = s.getLastColumn();
var targetSheet = ss.getSheetByName("CLOSED");
var target = targetSheet.getRange(targetSheet.getLastRow() + 1, 1);
s.getRange(row, 1, 1, numColumns).copyTo(target);
s.deleteRow(row);
}
}