Status Update
Comments
ma...@gmail.com <ma...@gmail.com> #2
he...@gmail.com <he...@gmail.com> #3
edit: Seems to work as usual again for me. (Started to be fine again, while others still reported this issue. Seems to not affect everyone at the same time...)
edit2: Small update: Now, the issue came back again. :)
sp...@manx.net <sp...@manx.net> #4
Have a spreadsheet importing data from an external api, however, this morning this has completely broken and the data is no longer loading into the sheet. Have confirmed the issue is not with the script.
en...@gmail.com <en...@gmail.com> #5
ta...@gmail.com <ta...@gmail.com> #6
km...@gmail.com <km...@gmail.com> #7
ma...@gmail.com <ma...@gmail.com> #8
ma...@gmail.com <ma...@gmail.com> #9
It's really bad for our business, please act!
al...@gmail.com <al...@gmail.com> #10
ro...@gmail.com <ro...@gmail.com> #11
I then duplicated my sheet and started trimming EVERYTHING out of it, and have essentially a virgin sheet with nothing in it besides a doTest function, and even that fails.
It seems as though the sheet itself is broken and google will no longer execute and functions. Any thoughts? The sheet copy is located here:
ma...@gmail.com <ma...@gmail.com> #12
But i found a fix for myself:
After i shared that sheet with another google account and there made a copy of that, everything works fine (in the other account).
Then shared the new copy with my own account and made a copy of that again it works .
So the new copy works now in my account, the original version still doesnt work.
EDIT: Now the copy also doesnt work anymore. Seems like a bigger problem. Or a new limitation of function calls or something. :/
ro...@gmail.com <ro...@gmail.com> #13
Created a copy of the shared sheet in the separate account - copy didn't work.
Please try the link I provided. Does it work for you?
ma...@gmail.com <ma...@gmail.com> #14
ro...@gmail.com <ro...@gmail.com> #15
I know a fresh sheet works. My issue is the current sheet. The original sheet cannot be changed or use a new blank sheet from scratch (in the real case).
Is there a way to repair the sheet in the link? It seems like the custom functions are not calling.
ma...@gmail.com <ma...@gmail.com> #16
EDIT: Now the copy also doesnt work anymore (mine and yours). Seems like a bigger problem. Or a new limitation of function calls or something. :/
ky...@gmail.com <ky...@gmail.com> #17
es...@gmail.com <es...@gmail.com> #18
rt...@blacksparkcorp.com <rt...@blacksparkcorp.com> #19
ca...@gmail.com <ca...@gmail.com> #20
rt...@blacksparkcorp.com <rt...@blacksparkcorp.com> #21
lg...@gmail.com <lg...@gmail.com> #22
Also, I can't load the script file.
ja...@rmit.edu.au <ja...@rmit.edu.au> #23
Some functions defined directly in the local sheets container also failing.
Functions that are executed by triggers or via custom menus still seem to work, but some have run very slow and timed out.
ma...@gmail.com <ma...@gmail.com> #24
mu...@google.com <mu...@google.com> #25
Hello everyone,
Thank you for reaching out and for your constant interest regarding Google products! I was able to reproduce this and I have forwarded all the information intenrally.
Best regards
ta...@gmail.com <ta...@gmail.com> #26
1. Change the formula in the cell = No success
2. Change the value used by the cell = No success
3. Make a copy of the sheet and function = No success
4. Create a new sheet, use the in-sheet menu to create a new function coded simply myFunction to return 1 = No success
I've found that function that respond to calls from outside GoogleSheet like doGet() works normally.
Failed calculation of custom functions defined in the sheet also does not show on execution log.
an...@gmail.com <an...@gmail.com> #28
ro...@gmail.com <ro...@gmail.com> #29
This has completely shut down all new business for my company. The entry point to my pipeline is 100% dependent upon this...
mu...@google.com <mu...@google.com> #30
I can assure you that this is currently being researched internally and any updates regarding this will be posted here.
fp...@gmail.com <fp...@gmail.com> #31
ef...@gmail.com <ef...@gmail.com> #32
ak...@mixedanalytics.com <ak...@mixedanalytics.com> #33
an...@lespaniersmixtes.fr <an...@lespaniersmixtes.fr> #34
ti...@cloudkitchens.com <ti...@cloudkitchens.com> #35
sh...@intuitsolutions.net <sh...@intuitsolutions.net> #36
mi...@svfeeds.com <mi...@svfeeds.com> #37
On an interesting note, the same function and data pull is not slow on my personal/free account but our paid business account is crippled.
*Update* Another bit of oddness that may be worth noting is that I created a new blank sheet and recreated the failing sheet without any copying except for the code. The sheet ran perfectly for almost exactly an hour then quit working like the original. Just before it quit working I had added about 30 Logger.log() calls to help with timing the steps involved. After the new sheet failed I removed those Logger calls and the sheet is continuing to fail. Might just be coincidental timing.
so...@gmail.com <so...@gmail.com> #38
ch...@gmail.com <ch...@gmail.com> #39
es...@gmail.com <es...@gmail.com> #40
he...@gmail.com <he...@gmail.com> #41
fe...@gmail.com <fe...@gmail.com> #42
sh...@gmail.com <sh...@gmail.com> #43
st...@gmail.com <st...@gmail.com> #44
ig...@hotmail.com <ig...@hotmail.com> #45
al...@gmail.com <al...@gmail.com> #46
rt...@blacksparkcorp.com <rt...@blacksparkcorp.com> #47
di...@gmail.com <di...@gmail.com> #48
ro...@gmail.com <ro...@gmail.com> #49
Please escalate priority level immediately.
ch...@gmail.com <ch...@gmail.com> #50
+1
[Deleted User] <[Deleted User]> #51
My custom function normally shows in the execution log, and today it stopped showing after 3:36:23 PM UTC.
lu...@takejame.com.br <lu...@takejame.com.br> #52
ki...@gmail.com <ki...@gmail.com> #53
Custom functions all stucks. When hoovering it displays: Unknow function.
fr...@icigo.com <fr...@icigo.com> #54
no update on the code before it happened, it just randomly happened out of nowhere
da...@gmail.com <da...@gmail.com> #55
ro...@gmail.com <ro...@gmail.com> #56
es...@asiarobotica.com <es...@asiarobotica.com> #57
ef...@gmail.com <ef...@gmail.com> #58
Brazil
an...@lespaniersmixtes.fr <an...@lespaniersmixtes.fr> #59
Guys, try to make the exact same requests from another sheet.
Luckily on my side its working again after 20 hours out.
rt...@blacksparkcorp.com <rt...@blacksparkcorp.com> #60
ch...@gmail.com <ch...@gmail.com> #61
jo...@oxfcol.es <jo...@oxfcol.es> #62
au...@gmail.com <au...@gmail.com> #63
DD.MM.YYYY HH:MM:SS
28.02.2021 19:49:33
02.03.2022 06:49:52
03.03.2022 03:49:53
03.03.2022 18:49:53
03.03.2022 23:49:54
04.03.2022 00:49:54
04.03.2022 09:49:54
04.03.2022 10:49:54
04.03.2022 11:49:53
04.03.2022 12:49:54
04.03.2022 13:49:54
04.03.2022 14:49:55
04.03.2022 15:49:53
04.03.2022 16:49:54
04.03.2022 17:49:54
04.03.2022 18:49:55
04.03.2022 19:49:56
04.03.2022 20:49:54
04.03.2022 21:49:54
04.03.2022 22:49:54
04.03.2022 23:49:54
05.03.2022 00:49:54
05.03.2022 01:49:54
05.03.2022 02:49:53
05.03.2022 03:49:54
05.03.2022 04:49:53
05.03.2022 05:49:54
05.03.2022 06:49:54
05.03.2022 07:49:55
05.03.2022 08:49:54
Hope it helps and good luck
ta...@gmail.com <ta...@gmail.com> #64
roughly 3 hour after I commented, the problem comes back. Right now custom function simply return 1 doesn't work
t
ma...@gmail.com <ma...@gmail.com> #65
na...@gmail.com <na...@gmail.com> #66
io...@gmail.com <io...@gmail.com> #67
xx...@gmail.com <xx...@gmail.com> #68
re...@gmail.com <re...@gmail.com> #69
pa...@gmail.com <pa...@gmail.com> #70
ca...@gmail.com <ca...@gmail.com> #71
ka...@gmail.com <ka...@gmail.com> #72
an...@onezerozero.eu <an...@onezerozero.eu> #73
mo...@gmail.com <mo...@gmail.com> #74
ed...@gmail.com <ed...@gmail.com> #75
he...@gmail.com <he...@gmail.com> #76
Edit:
Mine has nothing special, just multiple for's / if's and that's it, I actually changed it to just return 100 ....same results.
EDIT2: MINE IS FIXED
EDIT3: I shouldn't have said anything.... nope, stopped working again..
ke...@gmail.com <ke...@gmail.com> #77
md...@gmail.com <md...@gmail.com> #78
be...@bertiecharlton.com <be...@bertiecharlton.com> #79
m....@gmail.com <m....@gmail.com> #80
th...@gmail.com <th...@gmail.com> #81
da...@gmail.com <da...@gmail.com> #82
rt...@blacksparkcorp.com <rt...@blacksparkcorp.com> #83
"Thank you for contacting Google Workspace support.
Please be advised still there is no update on this BUG. The team still working on this issue, also they have not given any time frame for this issue.
As soon as I get any update, I will reach back to you."
cr...@gmail.com <cr...@gmail.com> #84
oy...@facilitatedworkhub.no <oy...@facilitatedworkhub.no> #85
I'm testing with the example from
It's been hanging for hours. I have tried with different computer, user, new sheet ... its just hanging.
/**
* Multiplies the input value by 2.
*
* @param {number} input The value to multiply.
* @return The input multiplied by 2.
* @customfunction
*/
function DOUBLE(input) {
return input * 2;
}
I have meet this problem too many times over several months.
This weekend I've been working quite intensely with custom functions for Google Sheets, and its been working fine for maybe 70% of the time, but now its just hanging.
ma...@gmail.com <ma...@gmail.com> #86
rl...@gmail.com <rl...@gmail.com> #87
On 6/03/2022 7:26 pm, buganizer-system@google.com wrote:
mi...@gmail.com <mi...@gmail.com> #88
mi...@gmail.com <mi...@gmail.com> #89
App Scripts "Overview":
Project OAuth Scopes
No scopes are requested for this deployment
Does anyone know if this has something to do with the bug?
ke...@hotmail.com <ke...@hotmail.com> #90
rt...@blacksparkcorp.com <rt...@blacksparkcorp.com> #91
di...@gmail.com <di...@gmail.com> #92
ba...@gmail.com <ba...@gmail.com> #93
Same for me, it was working last week:
Sample function that stucks forever
function getSomething() {
return [1,2,3]
}
UPDATE: tested again on March the 9th; it works.
za...@gmail.com <za...@gmail.com> #94
Just shows how little importance Google gives to their Sheets service. They're probably gonna kill it like 90% of their products anyway, or at least restrict what custom functions can do
co...@gmail.com <co...@gmail.com> #95
problem in the last 6 or so days. You should know that this problem is
related to one that has been ongoing for over 7 years:
At least these problems are easy to see! Imagine all the poor souls relying
on AI that is similarly flawed?
On Mon, 7 Mar 2022, 6:32 am , <buganizer-system@google.com> wrote:
oy...@facilitatedworkhub.no <oy...@facilitatedworkhub.no> #96
The real function still have the same problem. "Error loading data ..."
I see the the other bug that has been referenced in this thread, has been going on for 7 years and got status "Won't Fix (Intended behavior)"
BTW, my sheet is importing data with ImportRange and that is working. It is the function that uses the data that is not working.
PS! Before you consider to change status to ""Won't Fix (Intended behavior)" please add some error message that can help us find out what is wrong in our code if that's where you think the problem is.
Please contact if I can help with testing.
ed...@gmail.com <ed...@gmail.com> #97
How this is still a P2 and not a P0, and an S2 and not an S0 is incredible to me. According to all the complaints above, no ones' sheets are working if they use scripts.
yz...@gmail.com <yz...@gmail.com> #98
oy...@facilitatedworkhub.no <oy...@facilitatedworkhub.no> #99
Amazing!
ma...@gmail.com <ma...@gmail.com> #100
mi...@iotventures.net <mi...@iotventures.net> #101
ph...@gmail.com <ph...@gmail.com> #102
"Loading" error message.
I copied the spreadsheet and the error is still there.
On Sun, Mar 6, 2022 at 5:54 PM <buganizer-system@google.com> wrote:
ja...@rmit.edu.au <ja...@rmit.edu.au> #103
It is affecting:
- custom functions called from cell formulas
- scripts assigned to images inserted into sheets
- scripts run from custom menus
Impacting business critical functions.
fe...@gmail.com <fe...@gmail.com> #104
ph...@gmail.com <ph...@gmail.com> #105
locking up, even 1-line functions were not executing. (The spreadsheet
could recognize if the function existed or not but was not executing the
first line of any custom function).
On Sun, Mar 6, 2022 at 10:06 PM <buganizer-system@google.com> wrote:
mi...@bugcrowd.com <mi...@bugcrowd.com> #106
zh...@gmail.com <zh...@gmail.com> #107
na...@coamix.co.jp <na...@coamix.co.jp> #108
mi...@svfeeds.com <mi...@svfeeds.com> #109
So I tried one of my old (currently failing) sheets in Brave and it fails. Is anyone else seeing the same result? Is this a problem caused by the latest version of Chrome / Chromium? Isn't Edge based on Chromium?
Would someone else please try this and let me know if they see the same result? If so I'll recreate the entire sheet again in Brave and report what I get.
It seems that Google isn't going to reply so we might as well take the bull by the horns and troubleshoot this.
ke...@gmail.com <ke...@gmail.com> #110
st...@udemy.com <st...@udemy.com> #111
za...@gmail.com <za...@gmail.com> #112
Someone from Google, please understand this is an important matter and speak to us.
st...@gmail.com <st...@gmail.com> #113
te...@rentokil-initial.com <te...@rentokil-initial.com> #114
if...@gmail.com <if...@gmail.com> #115
[Deleted User] <[Deleted User]> #116
ta...@gmail.com <ta...@gmail.com> #117
I hope the fix comes quickly because this is really unacceptable.
ha...@gmail.com <ha...@gmail.com> #118
My functions take large ranges as parameter (for e.g. B15:B) and are called in ~50 different cells
I have made certain changes to my sheet and now it seems to be working. Will get back if I face the errors again in few days
(my understanding is function is called everytime data changes in the parameter of the function is called)
* there was a dynamically updating cell in the range (B15 is GOOGLEFINANCE call). I have removed it and added a periodic function to update this cell.
* Made a wrapper function FUNC1(range){ return FUNC(range)} and replaced half cells with this function
nn...@melexis.com <nn...@melexis.com> #119
pa...@gmail.com <pa...@gmail.com> #120
I'm seeing a lot of these errors in the console when it happens:
Content Security Policy: The page’s settings blocked the loading of a resource at inline (“script-src”).
I wonder if there is some CORS problem with the services supporting "Apps Script". I wish Google would just integrate some basic scripting directly into sheets without this larger app scripting layer. There are a million ways to build applications already. We just want to import some data into our sheets with a little flexibility.
rt...@blacksparkcorp.com <rt...@blacksparkcorp.com> #121
"Update (March 7th): our fix has been gradually rolled out, and will be completely rolled out to all users by the end of today. We will really appreciate your patience if you still have the issue now. If you still encounter the issue tomorrow (March 8th U.S ET), please leave your comments in the post."
Hopefully the fix is the same for custom functions?
wi...@gmail.com <wi...@gmail.com> #122
li...@bumpinblends.com <li...@bumpinblends.com> #123
eq...@gmail.com <eq...@gmail.com> #124
ni...@apps4gs.com <ni...@apps4gs.com> #125
br...@doherty.net.nz <br...@doherty.net.nz> #126
6:25:22 PST. You can check this by going to the Apps Script editor,
switching to Executions, then filtering by Type = Custom Function.
On Tue, 8 Mar 2022 at 06:24, <buganizer-system@google.com> wrote:
an...@mhrn.ca <an...@mhrn.ca> #127
al...@enabler4excel.com <al...@enabler4excel.com> #128
eq...@gmail.com <eq...@gmail.com> #129
kl...@gmail.com <kl...@gmail.com> #130
[Deleted User] <[Deleted User]> #131
Time: 8:47 PM / 07.03.2022 / Poland
Well see for how long, and hopefully without any issues moving forward
an...@gmail.com <an...@gmail.com> #132
cn...@gmail.com <cn...@gmail.com> #133
rt...@blacksparkcorp.com <rt...@blacksparkcorp.com> #134
so...@mccoy.vc <so...@mccoy.vc> #135
va...@decathlon.com <va...@decathlon.com> #136
rt...@blacksparkcorp.com <rt...@blacksparkcorp.com> #137
Google rep said the fix being rolled out for IMPORTXML does NOT fix the custom functions stuck in Loading...
Also they could not provide any status or ETA on a fix.
eq...@gmail.com <eq...@gmail.com> #138
Oh great! Awesome Google! So should we wait till?
ts...@gmail.com <ts...@gmail.com> #139
mm...@gmail.com <mm...@gmail.com> #140
bl...@gmail.com <bl...@gmail.com> #141
All the sheets have similar custom functions (each sheet for one year, so pretty much similar content)
I experimented with a simple new app to return value of six regardless and even that does not get executed when in type this in one of the google sheets cell
"=Temp()"
function Temp() {
var dummyvar = 6
return dummyvar
}
al...@gmail.com <al...@gmail.com> #142
On Tue, Mar 8, 2022 at 9:34 AM <buganizer-system@google.com> wrote:
eq...@gmail.com <eq...@gmail.com> #143
São Paulo, Brazil
ch...@gmail.com <ch...@gmail.com> #144
- Peter Chabot
- chabot.peter@gmail.com <mailto:chabot.peter@gmail.com>
ch...@gmail.com <ch...@gmail.com> #145
- Peter Chabot
- chabot.peter@gmail.com <mailto:chabot.peter@gmail.com>
mu...@gmail.com <mu...@gmail.com> #146
I'm still facing this issue.
- Murali
mu...@gmail.com <mu...@gmail.com> #148
he...@gmail.com <he...@gmail.com> #149
sp...@manx.net <sp...@manx.net> #150
al...@xappex.com <al...@xappex.com> #151
[Deleted User] <[Deleted User]> #152
fi...@gmail.com <fi...@gmail.com> #153
rt...@blacksparkcorp.com <rt...@blacksparkcorp.com> #154
tr...@myko.ai <tr...@myko.ai> #155
al...@gmail.com <al...@gmail.com> #156
ta...@gmail.com <ta...@gmail.com> #157
ke...@gmail.com <ke...@gmail.com> #158
as...@gmail.com <as...@gmail.com> #159
eb...@gmail.com <eb...@gmail.com> #160
On Fri, Mar 18, 2022 at 9:40 AM <buganizer-system@google.com> wrote:
tr...@myko.ai <tr...@myko.ai> #161
eb...@gmail.com <eb...@gmail.com> #162
na...@inhabitr.com <na...@inhabitr.com> #163
ch...@gmail.com <ch...@gmail.com> #164
ma...@gmail.com <ma...@gmail.com> #165
tr...@gmail.com <tr...@gmail.com> #166
pa...@gmail.com <pa...@gmail.com> #167
tr...@myko.ai <tr...@myko.ai> #168
co...@gmail.com <co...@gmail.com> #169
da...@gmail.com <da...@gmail.com> #170
other linked issue x1820 is "access denied"
rt...@blacksparkcorp.com <rt...@blacksparkcorp.com> #171
tr...@myko.ai <tr...@myko.ai> #172
I would recommend creating a "new issue" with the tag "similar to the existing issue" or trying to directly contact support. It seems like these threads are a dead end channel and nobody has been working on this the whole time.
ha...@gmail.com <ha...@gmail.com> #173
ca...@auchan.com <ca...@auchan.com> #174
ke...@boldpenguin.com <ke...@boldpenguin.com> #175
e....@gmail.com <e....@gmail.com> #176
I have it too and It is a pain in the a**
sh...@gmail.com <sh...@gmail.com> #178
Staring at my spreadsheet "Loading..."
Staring, staring, "Loading..." "Loading...."
Execution log keeps running, functions calling, but not reloading...
Insane that this happens on paid business accounts. I'm new-ish to Google cloud services, and this has completely turned me off. Right now, switching to python scripts even if less convenient. Google's lost my vote. And my money.
ke...@boldpenguin.com <ke...@boldpenguin.com> #179
br...@idautomation.com <br...@idautomation.com> #180
Sometimes it displays "Loading..." in the cell and you have to refresh the screen to get it to show up in the cell.
ky...@communicationconstruction.com <ky...@communicationconstruction.com> #181
I see this is marked as "Fixed" on the right under "Status", where is this fix posted?
ip...@googlemail.com <ip...@googlemail.com> #182
+1
hy...@gmail.com <hy...@gmail.com> #183
hy...@gmail.com <hy...@gmail.com> #184
al...@zillowgroup.com <al...@zillowgroup.com> #185
be...@parakeeto.com <be...@parakeeto.com> #186
go...@gmail.com <go...@gmail.com> #187
ga...@gmail.com <ga...@gmail.com> #188
da...@craftdepot.ca <da...@craftdepot.ca> #189
"Script Function cannot be found".
No coding changes...
mu...@gmail.com <mu...@gmail.com> #190
cc...@gmail.com <cc...@gmail.com> #191
mi...@gmail.com <mi...@gmail.com> #192
pa...@gmail.com <pa...@gmail.com> #193
jo...@gmail.com <jo...@gmail.com> #194
Was working fine last month, but now having error loading data issue or can't fetch URL, on Importhtml, when just a week ago it was working fine
be...@gmail.com <be...@gmail.com> #195
rt...@blacksparkcorp.com <rt...@blacksparkcorp.com> #196
All of the relevant threads on
The last post by a Google rep on this thread says go to this issue for updates:
So you may want to try posting there, instead.
Otherwise, it seems like Google has abandoned the issue.
li...@kitware.com <li...@kitware.com> #197
su...@gmail.com <su...@gmail.com> #198
be...@gmail.com <be...@gmail.com> #199
ru...@gmail.com <ru...@gmail.com> #200
ma...@gmail.com <ma...@gmail.com> #201
As of today, the general problem affecting custom functions seems to be still there, at least in Belgium.
It would be more appropriate if feedback were to be provided here.
Thanks
ju...@energetica.coop <ju...@energetica.coop> #202
dr...@gmail.com <dr...@gmail.com> #203
Wiped the cache, no improvement.
ms...@gmail.com <ms...@gmail.com> #204
ge...@gmail.com <ge...@gmail.com> #205
th...@hrc-consulting.fr <th...@hrc-consulting.fr> #206
Running the function again after changing some data used in the script makes it load forever as well...
It may start working again after some time, but it may be days. And it usually not works for long.
ma...@gmail.com <ma...@gmail.com> #207
1) According to our experience, the main reason a function would freeze is when the graphical layer of Google Sheets does not take into account that the function has returned data.
2) Second case is when the function script is not even executed
To know if you're in one case or the other:
- Add a log at the end of the function just before the return statement and check in the log explorer that it has been triggered.
- or create and execute the following apps script function
function getValueBehindFrozenCell(your_Frozen_Cell) {
let expectedValue = SpreadsheetApp.getRange( your_Frozen_Cell ).getValue())
console.log(expectedValue)
return expectedValue
}
if the result is as expected, it verifies that the function actually finished its execution and therefore, that the issue is on the display.
It seems that case 1) appears more in computers with lower performances (perhaps related to the graphical card)
Would be great if you could precise in which case you're in.
wi...@gmail.com <wi...@gmail.com> #208
sb...@gladia.io <sb...@gladia.io> #209
pa...@gmail.com <pa...@gmail.com> #210
This appears to happen just when I embed the sheet in a website.
This is my script:
function dexscreenerPrice(token, field = "priceUsd") {
var jsondata = UrlFetchApp.fetch("
var object = JSON.parse(jsondata.getContentText());
return object.pairs[0][field]
}
ma...@terpmail.umd.edu <ma...@terpmail.umd.edu> #211
je...@gmail.com <je...@gmail.com> #212
co...@gmail.com <co...@gmail.com> #213
On Mon, 19 Dec 2022, 11:35 , <buganizer-system@google.com> wrote:
ca...@oshcut.com <ca...@oshcut.com> #214
js...@gmail.com <js...@gmail.com> #215
What is weird is that the graphs based on these cells are correct, as if the cells had loaded. But on the cells, they say "Loading...".
rt...@blacksparkcorp.com <rt...@blacksparkcorp.com> #216
In Chrome:
Access "More Tools" from the ellipsis (3 dots) menu in the top right nav bar. Select "Clear browsing data", Time Range - All time, check History, Cookies and Cache. Click Clear data button, it will probably log you out at this point.
Log back in and see if the "Loading..." is cleared.
jc...@gmail.com <jc...@gmail.com> #217
The original report here was about a complete and total outage that has long been fixed and resolved.
There is also an intermittent issue I see from time to time where one or several invocations of a custom function stop loading. The solution I've found to that has been to call the function with an extra argument (typically the number 1) and fill that change across the array of cells calling the function. This extra argument is silently dropped since the function doesn't take that many parameters, but forces a bypass of the cache and gets the result to load. Each time it fails, I just increment this extra argument in the top left cell and fill the array again.
st...@gmail.com <st...@gmail.com> #218
ca...@tricamtech.com <ca...@tricamtech.com> #219
ra...@nomad.systems <ra...@nomad.systems> #220
da...@bancherosanitarios.com.ar <da...@bancherosanitarios.com.ar> #221
ti...@mongodb.com <ti...@mongodb.com> #222
tk...@gmail.com <tk...@gmail.com> #223
la...@adnudging.com <la...@adnudging.com> #224
na...@nurun.com <na...@nurun.com> #225
ma...@gmail.com <ma...@gmail.com> #226
Facing this error now, this may be connected with the new functions VSTACK
, etc.
Useful resource:
My tests showed that even simple custom functions loading slowly:
/** testFunc
*
* Get a number 10
*
* @return {Int} number 10
*
* @customfunction
*/
function testFunc(arg) {
var val = arg[0][0];
return [[10, 10], [10, 10], [val, val]];
}
Things get worse if I use native functions to calculate arguments for my custom function:
=testFunc(SORT(OFFSET...))
Hope this helps
li...@isovalent.com <li...@isovalent.com> #227
ch...@airbus.com <ch...@airbus.com> #228
Can confirm that the intermittent bug is 100% still found for me and that this is not fixed
Workaround from
The problem seems to occur the most when custom functions take arguments that are references to cells that themselves are custom functions or calculated. Replacing the cell reference with a number will nearly always remove the "loading..." error but then isn't a working spreadsheet
Edit from 10th May 2023: I'm building an important Sheet to replace (only partially) an Excel spreadsheet that is used for very important internal training and it is now 100% broken because of this bug. It no longer works, adding fake arguments and re-loading doesn't work, completely re-editing and re-writing functions doesn't work. This is NOT a complex Sheet compared to the Excel version, all it has is some very simple custom functions and it means that I will have to revert to Excel unless someone at Google or I can find a way to fix it
mr...@gmail.com <mr...@gmail.com> #229
tk...@gmail.com <tk...@gmail.com> #230
zk...@viessmann.com <zk...@viessmann.com> #231
ca...@gmail.com <ca...@gmail.com> #232
gu...@gmail.com <gu...@gmail.com> #233
gu...@gmail.com <gu...@gmail.com> #234
My Apps Script function, called by a Sheets formula, worked fine one moment then 30s later started "Loading..." forever.
It ends with "return [[count,key]]" (two cells in a row).
I modified it to "return count", it works. Then "return key", also works.
Back to "return [[count,key]]", back to eternal "Loading..."
I'll crosspost this on other issues relating to the same problem hoping it will be seen by someone who actually can solve the problem.
[Deleted User] <[Deleted User]> #235
da...@allenapptools.com <da...@allenapptools.com> #236
jo...@gmail.com <jo...@gmail.com> #237
jo...@gmail.com <jo...@gmail.com> #238
Do we need to start a new issue ?
bo...@gmail.com <bo...@gmail.com> #239
ra...@nomad.systems <ra...@nomad.systems> #240
le...@nesta.org.uk <le...@nesta.org.uk> #241
tk...@gmail.com <tk...@gmail.com> #242
But please notice that this is marekd as Fixed, but not in Prod.....
dh...@gmail.com <dh...@gmail.com> #243
[Deleted User] <[Deleted User]> #244
co...@gmail.com <co...@gmail.com> #245
On Sun, 4 June 2023, 06:16 , <buganizer-system@google.com> wrote:
pr...@gmail.com <pr...@gmail.com> #246
al...@gmail.com <al...@gmail.com> #247
usually fixed = there is a solution or a workaround
Which is the solution to this bug?
Thanks to everybody that will answer to me.
gy...@gmail.com <gy...@gmail.com> #248
co...@gmail.com <co...@gmail.com> #249
advantage, not meaning repaired.
On Thu, 20 July 2023, 09:05 , <buganizer-system@google.com> wrote:
su...@veolia.com <su...@veolia.com> #250
Very frustrating also that when you reload, you see the data pop back in the sheets while its thinking, then it wipes it all out
Guess its back to excel and manually importing data on a weekly basis from Google derived databases
How do we get this reopened?
st...@revevol.eu <st...@revevol.eu> #251
mi...@gmail.com <mi...@gmail.com> #252
Broken for me as well. But I found a workaround: I have a function call within multiple cells like this: =NXT_CONCATENATE(F49, 81, 84)
The following steps help me to fix broken cells:
- Copy the content of a cell
- Remove the content from that cell
- Leave that cell
- Enter that cell
- Paste the formula
om...@gmail.com <om...@gmail.com> #253
gc...@splunk.com <gc...@splunk.com> #254
ma...@gmail.com <ma...@gmail.com> #255
In my sheet, the same (simple) function is called at the same time in a large number of cells.
This creates a large number of parallel elaboration cycles exceeding the limits of the free application.
These limits are described here:
There is a suggested workaround for the problem.
Hope this helps.
al...@banregio.com <al...@banregio.com> #256
This is my report to Xertica and Google Workplace
Google Workspace Support 46591123: Lentitud en funciones personalizadas ( Macros )
In another Google Sheets, it works with 44 thousand records, it fails me in this one that has 12 thousand records.
fu...@trimble.com <fu...@trimble.com> #257
tk...@gmail.com <tk...@gmail.com> #258
su...@nilenglish.com <su...@nilenglish.com> #259
ve...@gmail.com <ve...@gmail.com> #260
fa...@googlemail.com <fa...@googlemail.com> #261
hi...@gmail.com <hi...@gmail.com> #262
te...@gmail.com <te...@gmail.com> #263
ra...@nomad.systems <ra...@nomad.systems> #264
ra...@websheet.cc <ra...@websheet.cc> #265
al...@gmail.com <al...@gmail.com> #266
na...@coamix.co.jp <na...@coamix.co.jp> #267
I'm being told off for choosing to go with google workspace for such important work system. Please work this out google.
mi...@gmail.com <mi...@gmail.com> #268
na...@coamix.co.jp <na...@coamix.co.jp> #269
rs...@gmail.com <rs...@gmail.com> #270
bl...@bellese.io <bl...@bellese.io> #271
vi...@gmail.com <vi...@gmail.com> #272
mp...@gmail.com <mp...@gmail.com> #273
da...@gmail.com <da...@gmail.com> #274
Doesn't happen always though, only in some cells at specific coordinates.
Only solution so far was to close the browser tab and reopen it.
I am using microsoft edge browser.
me...@gmail.com <me...@gmail.com> #275
ge...@sociobright.com <ge...@sociobright.com> #276
ry...@dpsnc.net <ry...@dpsnc.net> #277
This tip from rom #275 worked for me: This helped me. =1*1 in any random cell "jump started" the sheet.
Wait ~10 seconds or so.
For a long-term fix, I updated my spreadsheet and apps script to use a manually triggered function (via button) instead of cell-based custom formulas. Code below. This works fine, if not better, for me. Now I have more control over when the calculations are updated.
// Set a custom formula to this function: =countMatches(E6,"CountLookup!$D$6:$D$2000")
// However, custom formulas don't reliably update automatically, and often
// update when not needed.
// Better to manually trigger the update via a button (see updateMatches() below)
// For more info: https://issuetracker.google.com/issues/222342097
function countMatches(strA, strRangeA1Notation, ignoreCase=true) {
var ss = SpreadsheetApp.getActiveSpreadsheet();
var range = ss.getRange(strRangeA1Notation); // strRangeA1Notation example: "CountLookup!$D$6:$D$2000"
var values = range.getValues();
const MATCHING_SCORE_MIN = getMatchThreshold(); // Set the fuzzy match minimum threshold. Ex. 0.8
var count = 0;
for (var i in values) {
for (var j in values[i]) {
// getMatchScore performs a fuzzy match between first and second arguments
// Returning a score between 0 and 1.
if (getMatchScore(strA, values[i][j], ignoreCase) > MATCHING_SCORE_MIN) {
count++;
}
}
}
return count;
}
// Trigger this function from a button, instead of from a cell's custom formula.
// This avoids cells getting stuck showing "Loading...", and only updates
// the calculations when needed.
// More info at #275: https://issuetracker.google.com/issues/222342097?pli=1
// More info: https://stackoverflow.com/questions/63161404/app-script-functions-in-google-sheet-stuck-at-loading
function updateMatches() {
console.log("Updating counts.")
var ss = SpreadsheetApp.getActiveSpreadsheet();
var lastUpdatedCell = ss.getRange("CountLookup!$F$2"); // Display last runtime/status update here.
const scriptStartDate = new Date(); // Now
lastUpdatedCell.setValue("Started: " + scriptStartDate); // Update the cell showing last run time.
var uniquesRange = ss.getRange("CountLookup!$E$6:$F$2000"); // Note: 2 columns here: names and counts
var uniqueValues = uniquesRange.getValues();
var strDataRange = "CountLookup!$D$6:$D$2000"; // Data range to search for matches.
// i and j are row/column of the range, relative to the range, starting at 1.
// See getCell, getHeight, getWidth:
// https://developers.google.com/apps-script/reference/spreadsheet/range#getCell(Integer,Integer)
for (var i = 1; i <= uniquesRange.getHeight(); i++) {
for (var j = 1; j < uniquesRange.getWidth(); j++) {
var uniquesCell = uniquesRange.getCell(i, j); // Ex. E6
var strUniqueName = uniquesCell.getValue(); // Ex. LASTNAME FIRSTNAME
if (strUniqueName.length > 0) {
var countsCell = uniquesRange.getCell(i, j+1); // Adjacent cell from the counts column.
var currentCell = countsCell.activateAsCurrentCell(); // Selects/highlights the cell in the Sheets interface.
var count = countMatches(strUniqueName, strDataRange, true); // Count the number of fuzzy matches.
console.log(currentCell.getA1Notation() + "(" + strUniqueName + ") = " + count);
currentCell.setValue(count); // Save value in adjacent cell from the counts column.
}
}
}
lastUpdatedCell.setValue("Finished: " + scriptStartDate); // Update the cell showing last time updated.
}
jo...@newdawnpro.net <jo...@newdawnpro.net> #278
gu...@gmail.com <gu...@gmail.com> #279
do...@gmail.com <do...@gmail.com> #280
al...@gebele.com <al...@gebele.com> #281
al...@gmail.com <al...@gmail.com> #282
jp...@google.com <jp...@google.com>
is...@google.com <is...@google.com>
bl...@google.com <bl...@google.com> #283
[Deleted User] <[Deleted User]> #284
ra...@gmail.com <ra...@gmail.com> #285
Please fix this.
Like others have said, the product is unusable, which is a shame as otherwise I love Google Sheets over Excel - mainly because of the functions.
ab...@proxidize.com <ab...@proxidize.com> #286
ni...@withblaze.app <ni...@withblaze.app> #287
no...@gmail.com <no...@gmail.com> #288
mi...@dialecticanet.com <mi...@dialecticanet.com> #289
to...@gmail.com <to...@gmail.com> #290
am...@gmail.com <am...@gmail.com> #291
I mean, consider this case:
A1 = "This is some text within A1 cell"
B1 = GPT("What is this message talking about: "&A1)
If you move column B to another position say in column F this will cause the GPT formula to reload. That's clearly a bug because A1 will still be A1 within GPT formula. It seems that simply the re-rendering of the UI also causes custom functions like the one I wrote to reload.
Description
On some google sheets files custom functions coded in Apps Script are stuck in Loading intermittently.
Even simple functions like:
function DOUBLE(input) {
return input * 2
}
remain stuck in Loading for no reason. Then a few moments later they star to work again. This happens both in default and standard GCP projects.
A small code sample that reliably reproduces the issue. The sample should run as-is or with minimal setup, without external dependencies.
function DOUBLE(input) {
return input * 2
}
What is the expected output? What do you see instead? If you see error messages, please provide them.
When using =double(2) I expect to see 4, instead I see "Loading" forever.