具有自定义功能的 Google Sheets 插件未运行
我为 Google Sheets 编写了一个附加组件，其中包含一些自定义函数。这几个月来一直运行良好，但今天突然开始出现一些电子表格问题。我们看到的问题是自定义函数根本没有运行，它们只是永远显示 Loading... 。
我做了很多搜索，但没有任何建议对这种情况有帮助。我还尝试了很多调查，我发现最值得注意的一点是这些功能似乎根本没有运行。我通过查看 Apps 脚本执行日志来确定这一点。对于函数起作用的情况，我在日志中看到这些自定义函数为“已完成”，但对于不起作用的情况，根本没有日志条目（没有错误或任何内容）。
我应该澄清一下，问题似乎与电子表格相关。也就是说，这些函数在某些电子表格中运行良好，但在其他电子表格中不起作用。另外，我的附加组件公开了多个自定义函数，当发生此问题时，所有函数都会发生此问题。
此外，我发现这个问题有时会发生在新创建的空电子表格中，但其他时候则很好。
正如我上面提到的，几个月来一切都运行良好，所以我不认为这是我的功能的错误。
还有其他人看到这样的问题吗？有人对如何进一步调查有建议吗？还有其他想法吗？
I have written an add-on for Google Sheets that contains some custom functions. This has been working fine for months, but suddenly today it started have problems for some spreadsheets. The problem we're seeing is that the custom functions are not running at all, they just show Loading... forever.
I've done a lot of we searching, but none of the suggestions have helped in this case. I've also tried a lot of investigation and the most notable point I've found is that it seems these functions are not running at all. I'm determining that by looking at the Apps Script Execution Logs. For the cases when the functions works I see these custom functions in the log as Completed, but for the cases when it does not there is no log entry at all (no error or anything).
I should clarify that the problem seems to be spreadsheet related. That is, the functions work fine in some spreadsheet, but don't work in others. Also, my add on exposes multiple custom functions, and when this problem is happening it happens for all of the functions.
Furthermore, I've seen that this problem sometimes happens in a freshly created empty spreadsheet, but other times it is fine.
As I mentioned above, everything has been working fine for months, so I don't think it is a bug with my functions.
Is anyone else seeing problems like this? Does anyone have suggestions on how to investigate further? Any other ideas?
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论
评论（1）
您可能需要在问题跟踪器中为问题 222342097加注星标。单击左上角的星号图标☆ 为解决问题投票并获得状态更改通知。请不要发表“我也是”或“+1”回复，只需单击星号图标即可。 Google 优先考虑星级最多的问题。
You may want to star issue 222342097 in the issue tracker. Click the star icon ☆ in the top left-hand corner to vote for fixing the issue and get notified of status changes. Please do not post a "me too" or "+1" reply, but just click the star icon. Google prioritizes issues with the most stars.