Fixed
Status Update
No update yet.
Comments
ar...@google.com
ke...@gmail.com
much needed
sa...@gmail.com
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!
ke...@gmail.com
will really appreciate this feature :)
al...@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.
er...@gmail.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
ke...@gmail.com
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?
ke...@gmail.com
This trigger would also be useful for the code I'm working on.
Description
However due to Android team's misunderstanding of the reproduce steps, you have changed that issue to "Not Reproducible" by mistake.
Please reopen it and fix the issue
.
I have pointed out the misunderstanding in the following reference:
Reference
Reproduce steps from
"
1) Compile and deploy sample app in Android O device
2) Start the app
3) Go to background for instance by clicking home button
Next step you have to do within 60 seconds from step 3)
4) Open Recent apps list and swipe away the sample app
This will restart bg service
-----------
Note "ha...@google.com" DID NOT do this at all, instead, he just left the app by pressing back button, this made him think "Not Reproducible"
-----------
5) Wait for 1 minute or longer (up to you)
6) Go to Settings>System>Developer Options> Running Services > BGServiceTest
7) You should see that BG service is up and running for > 1 min
"