Status Update
Comments
jp...@google.com <jp...@google.com>
oh...@gmail.com <oh...@gmail.com> #2
Kk, got a more contained example of the issue using a very small add-on.
source:
https://script.google.com/d/1o3AvP1zRrx7WnDEx_fV_IhS2fc3QstuKHvFaBsqjcffqxdhLNjC7j62S/edit?usp=sharing
add-on listing:
https://chrome.google.com/webstore/detail/dcpikpbagjcipkfmacefilfbkdjlfjmd
Because I've made the add-on "unlisted" there are slightly different reproduction steps:
* Steps 1-4 are the same as in my original post
5. In the Incognito window that you're testing this in, open the following link
https://chrome.google.com/webstore/detail/auth-issue-tester/dcpikpbagjcipkfmacefilfbkdjlfjmd?authuser=1
The "authouser=1" query parameter is very important in the above link as otherwise the add-on will be installed for the "default" account and the issue won't express.
6. Click the "+ Free" button on the above linked page to install the add-on
7. In the new Sheet you will be brought to after clicking "+ Free", wait a few seconds for prompt to appear. Click "continue" and then authorize the add-on
8. Open the Dev console
9. Go to "Add-Ons" => "Auth Issue Tester" => "Open Sidebar"
10. Note the error printed to the console and inserted into the sidebar
Demo of the above listed steps 5-10:https://cl.ly/0p0v080F2j1s
source:
add-on listing:
Because I've made the add-on "unlisted" there are slightly different reproduction steps:
* Steps 1-4 are the same as in my original post
5. In the Incognito window that you're testing this in, open the following link
The "authouser=1" query parameter is very important in the above link as otherwise the add-on will be installed for the "default" account and the issue won't express.
6. Click the "+ Free" button on the above linked page to install the add-on
7. In the new Sheet you will be brought to after clicking "+ Free", wait a few seconds for prompt to appear. Click "continue" and then authorize the add-on
8. Open the Dev console
9. Go to "Add-Ons" => "Auth Issue Tester" => "Open Sidebar"
10. Note the error printed to the console and inserted into the sidebar
Demo of the above listed steps 5-10:
jp...@phageguard.com <jp...@phageguard.com> #3
Thank you for your report. The Apps Script team is investigating.
ri...@basichomeloan.com <ri...@basichomeloan.com> #4
mm...@dealmakerwealthsociety.com <mm...@dealmakerwealthsociety.com> #5
I was the person who originally reported this issue to Streak.
fl...@gmail.com <fl...@gmail.com> #6
I am facing similar issue. Getting error "You do not have permission to call showSidebar" on Opening the file (Docs, Sheets etc..)
Since yesterday, I am getting an exception when calling showSidebar() function with in onOpen().
I am building custom menu onOpen and calling showSidebar() function with in onOpen(). I want run check a few things in a Google Sheet every time the file is open and display an alert and sidebar if certain condition is not met.
The functionality was working perfectly, until yesterday!!
Below is the error that I am getting onOpen()
"You do not have permission to call showSidebar"
I have been using the same script from beginning of this year and never had this issue. I started seeing it since yesterday. Just wondering recent changes to OAuth scope to include " container.ui " is causing the issue.
Since yesterday, I am getting an exception when calling showSidebar() function with in onOpen().
I am building custom menu onOpen and calling showSidebar() function with in onOpen(). I want run check a few things in a Google Sheet every time the file is open and display an alert and sidebar if certain condition is not met.
The functionality was working perfectly, until yesterday!!
Below is the error that I am getting onOpen()
"You do not have permission to call showSidebar"
I have been using the same script from beginning of this year and never had this issue. I started seeing it since yesterday. Just wondering recent changes to OAuth scope to include " container.ui " is causing the issue.
mu...@gmail.com <mu...@gmail.com> #7
We and our clients numbering around 100 with Google App Scripts attached to spreadsheets found around the 11th of Nov that they needed to re-authorise apps to run. Notification email have been sent to us and our clients. Example below.
We alone received over 1000 email in one day like this for our internal application triggered either by Time or Form Submit.
We have spend over 100 hours reauthorising Google App Scrips so far. Our concern is that will this happen again and why has it happened?
------ Email Message ------
Your script, Client List, has recently failed to finish successfully. A summary of the failure(s) is shown below. To configure the triggers for this script, or change your setting for receiving future failure notifications, click here.
The script is used by the document Client List - Do Not Remove.
Summary:
Error Message Count
You do not have permission to call showModalDialog (line 16, file "Menu") 4
Start Function Error Message Trigger End
11/14/17 10:55 AM onOpen You do not have permission to call showModalDialog (line 16, file "Menu") open 11/14/17 10:55 AM
11/14/17 12:56 PM onOpen You do not have permission to call showModalDialog (line 16, file "Menu") open 11/14/17 12:56 PM
11/14/17 1:02 PM onOpen You do not have permission to call showModalDialog (line 16, file "Menu") open 11/14/17 1:02 PM
11/14/17 1:15 PM onOpen You do not have permission to call showModalDialog (line 16, file "Menu") open 11/14/17 1:15 PM
Sincerely,
Google Apps Script
We alone received over 1000 email in one day like this for our internal application triggered either by Time or Form Submit.
We have spend over 100 hours reauthorising Google App Scrips so far. Our concern is that will this happen again and why has it happened?
------ Email Message ------
Your script, Client List, has recently failed to finish successfully. A summary of the failure(s) is shown below. To configure the triggers for this script, or change your setting for receiving future failure notifications, click here.
The script is used by the document Client List - Do Not Remove.
Summary:
Error Message Count
You do not have permission to call showModalDialog (line 16, file "Menu") 4
Start Function Error Message Trigger End
11/14/17 10:55 AM onOpen You do not have permission to call showModalDialog (line 16, file "Menu") open 11/14/17 10:55 AM
11/14/17 12:56 PM onOpen You do not have permission to call showModalDialog (line 16, file "Menu") open 11/14/17 12:56 PM
11/14/17 1:02 PM onOpen You do not have permission to call showModalDialog (line 16, file "Menu") open 11/14/17 1:02 PM
11/14/17 1:15 PM onOpen You do not have permission to call showModalDialog (line 16, file "Menu") open 11/14/17 1:15 PM
Sincerely,
Google Apps Script
Description
For several months now, we have been receiving complaints from our customers about the operation of our custom function in Google Apps Script. The most common complaints are: "I'm getting the #NAME error, what should I do?" or Endless "Loading..." appears on my screen".
The problem is further complicated by the fact that many customers use our function in conjunction with COUNT and COUNTA functions, which obscures any error that might be occurring.
The function in question is called VALUESBYCOLOR and it is part of the "Power Tools" and "Function by Color" projects. This function uses "expensive" calls to SpreadsheetApp, like "getBackgrounds".
Here are my observations from some tests that I have conducted:
1) When there is a large number of functions (400 across the entire document) operating on small volumes of non-overlapping and unlinked data (about 60,000 cells, mostly numbers), an "Internal error executing the custom function" error is frequently encountered. What's strange is that when this function is the only one in the document or is the only one being calculated at a particular moment, it runs fine within 30 seconds.
The issue here also lies in the fact that when target ranges are changed, the customer may inadvertently trigger the recalculation of several functions, which then need to be manually triggered one by one for recalculation.
2) In a dataset with about 11,000 rows and 10 columns, where each row has a function that works with the data (mostly text) in that row, I found that it leads to an endless "Loading..." message and the document becomes completely inaccessible when attempting to use it through SpreadsheetApp or Sheets API. This behavior is quite unexpected.
In the attached video example, I have populated almost every cell with strings of 512 characters in length. Firstly, I haven't tried to find the minimum data volume threshold where the issue starts to manifest. Secondly, I am certain that this is not the weirdest case where users employ this function. Thirdly, the issue is consistently reproducible. Fourthly, when I experimented with simpler data, occasionally, instead of "Loading...", I observed the #NAME error on a part of functions.
3) Using the same data set as the previous case, but rather than applying a unique formula for each row, I dragged the function =SUM(VALUESBYCOLOR("yellow", "black", A1:J1820)) over 350+ rows.
After a long waiting period, I start to consistently observe the #NAME error. In the attached video example, I progressively added functions, but this did not help. Eventually, after a very long wait and dozens of document reloads, the error disappears. However, as soon as you change a value in the range specified as a function argument, everything starts all over again.
4) The scenario of using large ranges as function arguments often leads to memory overflow (in Google Chrome) and browser tab crashes.
Video: