'Refreshing a cell in sheets
I have this script:
var ss = SpreadsheetApp.getActiveSpreadsheet();
var sheet = ss.getSheetByName(sheetName);
var orig = sheet.getRange(row,col).getFormula();
var temp = orig.replace("=", "?");
sheet.getRange(row,col).setFormula(temp);
SpreadsheetApp.flush();
sheet.getRange(row,col).setFormula(orig);
}
It refreshes a cell. The sheet and cell that it refreshes is determined by:
function onEdit(e){
forceEval("Investments", 29, 61)
}
Right now it only refreshes column 61 (BI) row 29. I would like to make it so that it refreshes all cells from 29 down in column 61 (BI). Thanks for any help.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|
