1
votes

I have a function in google app script which changes the values of cells in a column.

var values = SpreadsheetApp.getActiveSheet().getDataRange().getValues()
for (var i = 1; i <= values.length; i++) {
    var fileId = values[i-1][1];
    var body = someOeration(fileId)
    SpreadsheetApp.getActiveSheet().getRange(i, 3).setValue(body);
}

Everything runs fine but values in spreadsheet gets updated once the complete code is executed. I want to see the changed cell value after every for loop execution and not the complete execution.

1
Thanks.. It was helpfulSanket Tarodekar

1 Answers

1
votes

Implement SpreadsheetApp.flush() according to the documentation