如何使自定义函数不在Google表格中重新计算 [英] how to make a custom function NOT recalculate in Google Sheet

问题描述

我发现每次登录时都会重新计算.特别是，当我登录时，包括UrlFetch在内的函数会重新计算并对该URL进行100次调用.我宁愿仅依靠我上次绘制的数据.有没有办法阻止(偶然)重新计算?

解决方案

感谢鲁宾的帮助:

无法禁用功能重新计算.

解决方法是(1.)进行切换".输入到该功能，而该功能处于不更新状态".将使该函数不返回任何内容.如果函数是单元格内的"= FUNCTION()"类型，则不幸的是，空返回值将覆盖您的数据.:/

(2)上面的单元内函数无论如何都会重新计算.显然，以其他方式触发的功能(不在单元格中)不会.

我可能要做的是编写将单元格公式放到单元格中的非单元内函数.只有在按下按钮时，它们才会运行，然后重新运行

I find that each time i log in. The heavy functions I have do recalculate. IN particular it is functions including UrlFetch that recalculate and make 100s of calls to the url when I log in. I would rather just rely on the data I drew last time. Is there a way to block (haphazard) recalculation?

解决方案

Thanks for Ruben's help:

Function recalculation cannot be disabled.

the workarounds are (1.) to make a "switch" input to the function, which while in "don't update state" would make the function return nothing. If the function is of the "=FUNCTION()", in-cell, type, the empty return will overwrite your data, unfortunately. :/

(2) Functions that are in-cell, as above, will recalc no matter what. While, clearly, functions that are triggered otherwise - not in cells - would not.

What I will probably do is to write non-in-cell functions that drop the formulas into the cells. These will run, and re-run, only when pressing a button

这篇关于如何使自定义函数不在Google表格中重新计算的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！