'Google Sheets add-on with custom functions not running
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?
Solution 1:[1]
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.
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|---|
| Solution 1 |