I have a script that can delete one or more named ranges. However, the sheet does not recompute either after the script finishes or after a flush command is given. The only way I can force a recalculation is to physically insert a new formula in an empty cell or change an existing one.
I've tried using just SpreadsheetApp.flush() to trigger, but it doesn't cause a recalc if there is no visible change to the sheet.
Is this a deficiency or is there a more sensible approach?
If the action taken upon the spreadsheet has no impact on any formulas, then there will be no recalculation. Deleting a named range, for example, has no recalculation impact unless that named range is referenced in a formula. (And if that's the case, then the spreadsheet was probably broken by the deletion.)
Spreadsheet.flush() does not force recalculation - it's only supposed to write pending changes to the spreadsheet. (And if that change doesn't affect formulas... you get the idea.)
The net result is that you're left with the solution you describe; you need to update a cell that's involved in calculations. Replacing a formula will do. Sorry, no magic incantation for this.
