问Google电子表格添加相同的单元格值

EN

function editSameCell(e) {
  var editedCell,calculatedValue,enteredValue,oldCellValue;

  //Currently the last part of this code runs for every cell edited
  //You should check the column and/or the row to only run the remaining
  //lines of code if the cell being edited is the cell that you want
  //changed

  oldCellValue = e.oldValue;

  Logger.log('oldCellValue: ' + oldCellValue);
  Logger.log('isNaN(oldCellValue): ' + isNaN(oldCellValue));

  if (isNaN(oldCellValue) || !oldCellValue) {
    return; //Quit here because if the user is entering text there should not
    //be a calculation done
  }

  editedCell = SpreadsheetApp.getActiveRange().getCell(1,1);

  enteredValue = editedCell.getValue();
  Logger.log('enteredValue: ' + enteredValue);
  Logger.log('typeof enteredValue: ' + typeof enteredValue);

  if (!enteredValue) {//If for example the cell value was deleted do not enter a new value
    return;  
  };

  calculatedValue = Number(oldCellValue) + Number(enteredValue);
  editedCell.setValue(calculatedValue);

}