Google电子表格自定义功能：运行的脚本过多 [英] Google Spreadsheet Custom Function: Too many scripts running

问题描述

我试图在Google Spreadsheet中创建一个自定义方法。我有以下方法来替换缺少的WEEKNUM方法。 （我留给第二个参数以允许上传excel文件。）

 函数WEEKNUM（inDate，dummy）{
 return Utilities.formatDate（inDate，GMT，w）; 
} 
  

我在一个电子表格中调用约400行两次（800次） 。

 错误：这个Google同时运行的脚本太多了用户帐号。 
  

有什么我可以解决的？我理解800很多，但不会超过内置函数的预期。我知道还有其他方法可以计算周数（例如 = LEFT（TEXT（A2;wd）; 2））但是我想知道它是甚至可以创建自定义的公式函数，不会受到这个看不见的天花板。

谢谢您的回复。

解决方案

你有自定义函数接收一个范围并输出一个数组。不需要使用数组形式，它也不会在自定义函数中工作。

I am trying to create a custom method in Google Spreadsheet. I have the following method to replace the missing WEEKNUM method. (I leave to second parameter in order to allow upload of excel files.)

function WEEKNUM(inDate, dummy){
  return Utilities.formatDate(inDate, "GMT", "w");
}

I call in method in approximately 400 rows twice (800 times) in one spreadsheet. Some of the formulas complete however for other I get this error message.

error: There are too many scripts running simultaneously for this Google user account.

Is there anything I can do to fix this? I understand 800 executions it a lot but not anymore than would be expected of built in functions. I know there are alternative ways to calculate the week number (such as =LEFT(TEXT(A2; "w d"); 2)) however I want to know if it is even possible to create custom formula functions that wont be subjected to this invisible ceiling.

Thank you in advanced for your replies.

解决方案

Have you custom function receive a range and output an array. No need to use an arrayformula, which also wont work on a custom function

这篇关于Google电子表格自定义功能：运行的脚本过多的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！