Fixed
Status Update
No update yet.
Comments
ar...@google.com
would be useful!
el...@getaround.com
much needed
rd...@gpcsolutions.fr
I need to monitor active sheet because I have different side bar for every sheet. What I'm doing now is running a JavaScript from the client side every 1s (second) to call google.script.run.monitorTabChange();. This function reads current active sheet's name and compares it with a sheet name that had been saved in a PropertyService during the last call of google.script.run.monitorTabChange();.
The spreadsheet with this script helps me with creating Purchase Orders. It pulls data from Salesforce and Quickbooks and generates a PO. So for every PO for every customer I am duplicating the spreadsheet and of course the script. The problem that I am facing is running out of quota. I have generated tons of POs already and each of them runs (even if the spreadsheet is not opened - I tested it) the 'monitorTabChange' function, which calls PropertyService. I have 100 000 quota for PropertyService calls. And I'm running out of it pretty quickly now.
The trigger 'OnSheetChange' would then save me (probably many others too) from this issue. At the same time it would saved Google tons of execution overhead (that could be significant if lots of people use the solution I do to track the sheet change).
Thanks!
The spreadsheet with this script helps me with creating Purchase Orders. It pulls data from Salesforce and Quickbooks and generates a PO. So for every PO for every customer I am duplicating the spreadsheet and of course the script. The problem that I am facing is running out of quota. I have generated tons of POs already and each of them runs (even if the spreadsheet is not opened - I tested it) the 'monitorTabChange' function, which calls PropertyService. I have 100 000 quota for PropertyService calls. And I'm running out of it pretty quickly now.
The trigger 'OnSheetChange' would then save me (probably many others too) from this issue. At the same time it would saved Google tons of execution overhead (that could be significant if lots of people use the solution I do to track the sheet change).
Thanks!
ar...@google.com
will really appreciate this feature :)
ke...@gmail.com
I'd like an onSwitchSheets event trigger with the following information available:
The sheet I'm switching from, active cell I'm switching from, active row I'm switching from, active col I'm switching from etc.
The sheet I'm switching to with ability to:
- land in a specific cell
- modify the contents of a cell or range of cells in the switch to sheet
- initiate a re-calculate in the target sheet after changes have been made.
Even better... onPreSwitch, onSwitch, onPostSwitch
Excessive code is required to implement the functionality I'm chasing without these hooks.
The sheet I'm switching from, active cell I'm switching from, active row I'm switching from, active col I'm switching from etc.
The sheet I'm switching to with ability to:
- land in a specific cell
- modify the contents of a cell or range of cells in the switch to sheet
- initiate a re-calculate in the target sheet after changes have been made.
Even better... onPreSwitch, onSwitch, onPostSwitch
Excessive code is required to implement the functionality I'm chasing without these hooks.
jo...@google.com
Any news from Google team?
i Would like to re-hide hidden sheets when user leaves it
i Would like to re-hide hidden sheets when user leaves it
rd...@gpcsolutions.fr
Hey Google,
This feature is highly in need for us. Can you please respond?
This feature is highly in need for us. Can you please respond?
in...@csgactuarial.com
This trigger would also be useful for the code I'm working on.
jo...@google.com
very mandatory
ja...@gmail.com
Needed!
mi...@drip.com
would be greatly apreciated
rd...@gpcsolutions.fr
I need something like this too
su...@gmail.com
Come on... I was happy to see the way Google implemented apps vs MS vba and decided to convert several off my office documents to google sheets, but there is no way this is going to happen without support for this "onSheetChange" feature. It really makes me wonder how many other basic features are missing in sheets. It only took 10 min. of investigation to put sheets on hold....
ar...@artooro.com
Really need this feature and it seems like something that would be very simple to implement. Knowing the current sheet is crucial for lots of operations and constantly checking that it hasn't changed seems very wasteful.
ge...@gmail.com
Need this, too
ji...@google.com
One and a half year, no update yet...
sf...@gmail.com
Oh come on Google folks! Surely you can incorporate this! Soooooooooo many people want this and really need it!
Description
development server. Didn't test production.
* SDK informations
* version 1.9.37
* Python
* Arch Linux (Kernel 4.5.2)
* Package from the AUR (I'm the maintainer)
Since 1.9.37 libraries usually provided by the SDK can't be imported (ImportError).
The sys.path generated by the SDK for the libraries is wrong and points one directory before the actual SDK.
The SDK is installed in /opt/google_appengine.
Sample defective sys.path (Personal directories redacted):
['/opt/google_appengine', '/usr/lib/python2.7', '/usr/lib/python2.7/lib-dynload', '/opt/lib/jinja2-2.6', '/opt/lib/pycrypto-2.6', '/opt/lib/ssl-2.7', '/opt/lib/webapp2-2.5.2', '/opt/lib/yaml-3.10', /opt/lib/markupsafe-0.15', '/opt/lib/setuptools-0.6c11', '/opt/lib/protorpc-1.0', /opt/lib/webob-1.1.1']
Sample working sys.path from SDK 1.9.36 (Personal directories redacted):
['/opt/google_appengine', '/usr/lib/python2.7', '/usr/lib/python2.7/lib-dynload', '/opt/google_appengine/lib/jinja2-2.6', '/opt/google_appengine/lib/pycrypto-2.6', '/opt/google_appengine/lib/ssl-2.7', '/opt/google_appengine/lib/webapp2-2.5.2', '/opt/google_appengine/lib/yaml-3.10', '/opt/google_appengine/lib/markupsafe-0.15', '/opt/google_appengine/lib/setuptools-0.6c11', '/opt/google_appengine/lib/protorpc-1.0', '/opt/google_appengine/lib/webob-1.1.1']