Status Update
No update yet.
Comments
ak...@gmail.com
Information redacted by Android Beta Feedback.
ww...@gmail.com
ro...@oklahomeseller.com
This issue started yesterday as far as I'm aware.
What I have tried so far:
1 Switching back and forth between V8 and the previous version -- no improvement
2 Obtaining the range object in A1 notation vs. Column / Row - no improvement
3 Running the function separately from any other code -- no improvement
mi...@google.com
Hello there!
Are you still able to reproduce this behavior? When I tried the code provided in
Kind regards.
ma...@gmail.com
ak...@gmail.com
Hello,
I just redid the test and it took 42 seconds. you may have done a test with a graph without data? all the interaction between appscript and spreadsheets is very slow, I tried to create a new sheet and redo but still the same result.
take another example, in a spreadsheets , if you have an appscript function, everything is blocked, even with the "IMPORTHTML" function.
paste this into a spreadsheets box and you will see:
=IMPORTHTML("
it stays stuck on "Loading" it's so long whereas it usually takes less than a second
it's all the same problem,
Cordially.
07...@gmail.com
mi...@google.com
Hi,
I have tested this multiple times with multiple accounts, and still cannot reproduce this behavior (
Also, can you please clarify whether you are executing this as a
If you can clarify that you are experiencing this without using custom functions, I'll proceed to report this internally.
ak...@gmail.com
function IMPORTHTML() is not custom functions,
you can test this please :
=IMPORTHTML("
mi...@google.com
IMPORTHTML is a built-in Sheets function, it doesn't have anything to do with Apps Script.
07...@gmail.com
function myFunction() {
let t = Date.now();
let ss = SpreadsheetApp.openById('1P1TnjtU4NlzoV8bkWZhDHqVd_tinh5cZeOrXwrd-c3I');
let sheet = ss.getSheetByName('test');
t = Date.now() - t;
console.log(t / 1e3); // 10 sec. !!!
}
st...@gmail.com
Sent from Yahoo Mail for iPhone
On Friday, March 4, 2022, 9:57 pm, buganizer-system@google.com wrote:
Replying to this email means your email address will be shared with the team that works on this product.
Changed
ak...@gmail.com added
function IMPORTHTML() is not custom functions,you can test this please :=IMPORTHTML("
_______________________________
Reference Info: 222342099 App script taking too much time reading from Google Sheets
component: Public Trackers > Google Workspace Developers > Apps Script
status: Assigned
reporter: ak...@gmail.com
assignee: mi...@google.com
cc: ak...@gmail.com
type: Bug
priority: P2
severity: S2
retention: Component default
Generated by Google IssueTracker notification system
You're receiving this email because you are subscribed to updates on Google IssueTracker
Unsubscribe from this issue.
fp...@gmail.com
mi...@google.com
Hi,
Have you noticed this behavior with any Apps Script function that interacts with Sheets (e.g. when executing the function directly from the script editor), or just with
mi...@google.com
Hi, I have reported this internally.
Any updates about this will be communicated here.
Thank you.
mi...@svfeeds.com
This is doing serious harm to our business.
all .getValues(), .setValue(), and =ImportHTML() are all impacted. This is a critical issue.
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.
fe...@gmail.com
vo...@gmail.com
an...@gmail.com
I am also experiencing this. Some additional details:
- Experiencing timeout (30 seconds) with onEdit() functions
- Identical script on 30+ sheets, but
only some[edit: all] sheets are having this error - All instances of this script/function have worked almost 100% for the past 2+ years
A code example:
function onEdit(e) {
console.log('start')
var theRange = e.range;
console.log('got range')
var theSheet = theRange.getSheet()
console.log('got sheet')
var theSheetName = theSheet.getName()
console.log('got sheet name')
var rangeWidth = theRange.getWidth()
console.log('got range width')
var rangeRow = theRange.getRow()
console.log('got range row')
...
}
produces:
- Mar 6, 2022, 3:02:27 PM | Debug | start
- Mar 6, 2022, 3:02:27 PM | Debug | got range
- Mar 6, 2022, 3:02:27 PM | Debug | got sheet
- Mar 6, 2022, 3:02:37 PM | Debug | got sheet name
- Mar 6, 2022, 3:02:37 PM | Debug | got range width
- Mar 6, 2022, 3:02:37 PM | Debug | got range row
(note how it seemingly took 10 seconds to get the sheet name)
This is only one instance/type of the error (which I assume is related). The first place where I isolated the issue was with, e.g.:
var theRange = sheet.getRange(1,1,1000,3)
console.log('got range')
var vals = theRange.getValues()
console.log('got values')
The script would log got range but would timeout ~20 seconds later without ever logging got values. This remained the same when I tried:
- changing the range reference to A1 notation
- changing to a smaller range
- changing to reference a range on a different sheet
- duplicating the whole spreadsheet (thinking that it was an indescribable error occurring on randomly selected spreadsheets)
These spreadsheets are employee timesheets, and these scripts/functions contain crucial business logic for payroll, so it is a very high priority issue for us.
an...@gmail.com
An update to the previous message. It started working last night and for some of this morning, but has now stopped working again.
an...@gmail.com
While looking for others with the same issue, I came across these:
Reading those posts, I realize it's possible they could be related—at least to my issue, but perhaps not for everyone else in this thread.
Later in my erroring script, it does something like ...setFormula("=importXML(...") Perhaps this is causing issues. I thought I'd narrowed down our issue to a different part of the code by watching the timestamps of console.log() steps, but now it seems likely that importXML could be somehow impacting things behind the scenes.
bl...@gmail.com
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 googe sheets cell
"=Temp()"
function Temp() {
var dummyvar = 6
return dummyvar
}
mi...@google.com
Hi!
A fix has been pushed and you shouldn't experience this behavior anymore.
Is anyone still experiencing this?
ak...@gmail.com
Hello I just tried just now it works well, hope it stays like this
thank you
vo...@gmail.com
here for any future problems before assuming that I have broke something.
On Tue, 8 Mar 2022, 13:58 , <buganizer-system@google.com> wrote:
mi...@google.com
I'm marking this as fixed.
If you start encountering this behavior again, please create a new issue.
Thank you.
Description
Before filing an issue, please read and follow these instructions carefully.
First, please search through existing issues to ensure that the bug has not already been reported. You can start the search here:https://issuetracker.google.com/savedsearches/566234
If the issue has already been reported, you can click the star next to the issue number to subscribe and receive updates. We prioritize responding to the issues with the most stars. You can also comment on the issue to provide any details of your experience with it.
If your issue has not been reported, please provide all of the following:
A short description of the issue:
A small code sample that reliably reproduces the issue. The sample should run as-is or with minimal setup, without external dependencies.
What steps will reproduce the problem?
var ss = SpreadsheetApp.openById("IDSpreadsheet");
sheet = ss.getSheetByName("NameSheetGraphe");
var chart = sheet.getCharts()[0];
What is the expected output? What do you see instead? If you see error messages, please provide them.
la fonction "getCharts()" est trés trés lente depuis se matin, en moyen 30 second , d'habitude c'est quelque millisecond. all functions to access spreadsheets are really slow.
Please provide any additional information below.