Force Google spreadsheet to re-evaluate a cell (or

问题:

I'm working on a spreadsheet that contains a lot of static configuration info. I'd like to not have to pass this large range around to every one of my custom functions; I do realize this breaks some of the assumptions and that I'll run into caching issues because of this, and not see all cells updating.

Is there any way for me to manually force a cell to completely re-evaluate itself (which I could call from an OnEdit trigger to the config area, or something similar)? It would be acceptable (though obviously not ideal) to force all cells to re-evaluate if that's the only way to do it.

I realize one way to counter this is to pass GoogleClock() around to every function, but I'm hoping to avoid that!

Thanks for any advice.

回答1:

You dont have to use googleclock, besides that no longer works on new sheets.
Pass the same cell reference to all your functions. With script, change that one cell to the current timestamp. All formulas will recalculate.