问每次活动单元格更改行时更新单元格值

EN

function onOpen() {
    SpreadsheetApp.getActiveSpreadsheet()
        .addMenu('Updater', [{name:"Use Current Row", functionName:"updateRow"}]);
} 
function updateRow() {
    var cellToUpdate = "A1";
    var sheet = SpreadsheetApp.getActiveSpreadsheet().getActiveSheet();
    // Get the row in which the cursor is active.
    var newRow = sheet.getActiveCell().getRow();
    sheet.getRange(cellToUpdate).setFormula("= .... ");
}