强制Google电子表格重新评估单元格（或所有单元格） [英] Force Google spreadsheet to re-evaluate a cell (or all cells)

问题描述

我正在制作一个包含大量静态配置信息的电子表格。我想不必将这个大范围传递给我的每一个自定义函数;我意识到这打破了一些假设，并因此而陷入缓存问题，并没有看到所有单元格的更新。

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.

有没有办法给我手动强制一个单元格完全重新评估自己（我可以从OnEdit触发器调用配置区域，或类似的东西）？如果这是实现它的唯一方法，那么强制所有的单元格重新评估是可以接受的（尽管显然不是理想的）。

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.

我认识到一种解决方法就是将 GoogleClock（）传递给每个函数，但我希望避免这种情况！

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.

推荐答案

您不必使用googleclock，除此之外不再适用于新工作表。

通过相同的单元格引用您的所有功能。使用脚本，将该单元更改为当前时间戳。所有的公式都会重新计算。

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.

这篇关于强制Google电子表格重新评估单元格（或所有单元格）的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！