google-apps-script - Google 表格中的标签之间的 2-Way 同步

Question

我有一个脚本应该在两个不同的选项卡中同步 2 列。由于某种原因，它不起作用。谢谢！这是脚本：

function onEdit(e){
  var ss = SpreadsheetApp;
  var sheet = ss.getActiveSpreadsheet();

  var sheet1 = sheet.getSheetByName('Sheet1');
  var sheet2 = sheet.getSheetByName('Sheet2');

  var cell = e.range;
  var value = cell.getValue();
  var currentRow = cell.getRow();
  var currentColumn = cell.getColumn();

  var activeWorksheet = ['Sheet1','Sheet2'];
  var columnEdit = [1,2];

  if( activeWorksheet.indexOf(ss.getActiveSheet().getName()) > -1 && columnEdit.indexOf(currentColumn) > -1 && currentRow > 1){
    sheet1.getRange(currentRow. currentColumn).setValue(value);
    sheet2.getRange(currentRow, currentColumn).setValue(value);
  };
};

标签： google-apps-scriptgoogle-sheets

Answer 1

错别字

sheet1.getRange(currentRow, currentColumn).setValue(value);