Fixed
Status Update
Comments
to...@t-senger.de <to...@t-senger.de> #2
would be useful!
[Deleted User] <[Deleted User]> #3
much needed
er...@gmail.com <er...@gmail.com> #4
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!
so...@gmail.com <so...@gmail.com> #5
will really appreciate this feature :)
to...@t-senger.de <to...@t-senger.de> #6
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.
so...@gmail.com <so...@gmail.com> #7
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
ma...@android.com <ma...@android.com> #8
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?
so...@gmail.com <so...@gmail.com> #9
This trigger would also be useful for the code I'm working on.
kb...@gmail.com <kb...@gmail.com> #10
very mandatory
md...@gmail.com <md...@gmail.com> #11
Needed!
ro...@restartgroup.com <ro...@restartgroup.com> #12
would be greatly apreciated
md...@gmail.com <md...@gmail.com> #13
I need something like this too
[Deleted User] <[Deleted User]> #14
Yes please - I have a goto last row but it only runs on open; would be great to run on every tab/sheet change
kb...@gmail.com <kb...@gmail.com> #15
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....
kb...@gmail.com <kb...@gmail.com> #16
I have a sidebar that shows filters for the active sheet - when you change the sheet I need to reconfigure my sidebar.
At the moment I use a mouse-over event on my sidebar AND a timer function to constantly monitor the current sheet.
It would be so much better if there were a trigger on sheet change.
Thanks
At the moment I use a mouse-over event on my sidebar AND a timer function to constantly monitor the current sheet.
It would be so much better if there were a trigger on sheet change.
Thanks
in...@gmail.com <in...@gmail.com> #17
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.
ma...@gmail.com <ma...@gmail.com> #18
Need this, too
jo...@gmail.com <jo...@gmail.com> #19
One and a half year, no update yet...
kb...@gmail.com <kb...@gmail.com> #20
Oh come on Google folks! Surely you can incorporate this! Soooooooooo many people want this and really need it!
ma...@android.com <ma...@android.com> #21
up
zh...@gmail.com <zh...@gmail.com> #22
+
ma...@gmail.com <ma...@gmail.com> #23
+
lo...@gmail.com <lo...@gmail.com> #24
Please Google team - this would be very helpful!!
en...@google.com <en...@google.com>
kb...@gmail.com <kb...@gmail.com> #25
+
md...@gmail.com <md...@gmail.com> #26
+
tr...@gmail.com <tr...@gmail.com> #27
Hello? Can't believe this hasn't been added yet.
cs...@gmail.com <cs...@gmail.com> #28
Is this getting added ? Google team are you guys listening?
ar...@gmail.com <ar...@gmail.com> #29
I really need this trigger. Please add. Is anyone responding to this request?
ar...@gmail.com <ar...@gmail.com> #30
There is at least 1 workaround posted about that I know of if anyone is desperate. It's a bit pffft though based on a timer from memory. I'm not that desperate ...
bo...@gmail.com <bo...@gmail.com> #31
I haven't actually tried them & I know some voters here may even be the contributors but in case anyone is frazzled for a workaround & hasn't come across them, even if a bit hacky >>
https://stackoverflow.com/questions/38160116/trigger-when-user-switches-between-sheets
https://webapps.stackexchange.com/questions/91812/how-can-i-trigger-a-function-when-switching-sheets-within-a-spreadsheet
ma...@android.com <ma...@android.com> #32
+
ma...@gmail.com <ma...@gmail.com> #33
need it also
jl...@gmail.com <jl...@gmail.com> #35
+
th...@gmail.com <th...@gmail.com> #36
Needed
lo...@gmail.com <lo...@gmail.com> #37
On change sheet would be very useful
ma...@gmail.com <ma...@gmail.com> #38
Really needed.
ma...@google.com <ma...@google.com>
ka...@google.com <ka...@google.com> #39
Needed. I want to reset something as soon as a particular sheet is viewed.
ma...@gmail.com <ma...@gmail.com> #40
Come on Google, this has been around for years ... would give greater control of the user experience if changing sheets causes an action.
Description
This error generates transaction failures in many NFC transactions.
Indeed, at line 1353 of this file (if (rw_t4t_read_file (0, 1, FALSE))), the presence of a tag is checked by sending a "Read Binary" command (ISO/IEC 7816-4 APDU) to the card.
This method is forbidden by the ISO/IEC 14443-4 standard which prescribes in its section 7.5.5 only two methods to check the PICC presence:
"
7.5.5 PICC presence check
The following methods may be used to check the presence of a PICC at any time including before any I-block exchange.
(...)
7.5.5.1 Method 1
The PCD may send an empty I-block and expect to receive an I-block from the PICC.
7.5.5.2 Method 2
Before the first I-block exchange, the PCD may send an R(NAK) block (with block number 0) and expect to receive an R(ACK) (with block number 1) block from the PICC (rule 12).
After the first I-block exchange, the PCD may either a) send an R(NAK) block (with current block number) and expect to receive an R(ACK) block from the PICC (rule 12), in which case the PCD should not retransmit its last I-block as mentioned in the note in rule 6,
or
b) toggle its block number then send an R(NAK) block and expect to receive the last I-block from the PICC (rule 11).
"
Both methods do not interfere with the ISO/IEC 7816-4 APDU management layer of the PCD and of the PICC, unlike the presence check with the Read Binary command which is currently implemented in Android.
The Android presence check implementation is a major problem which prevents from using Android NFC devices in all applications using a security mechanism requiring that the control of all the APDUs exchanged with the card.
There are millions of such cards, used nationwide in several major countries (e.g. Canada, Mexico, Israel, France, Italy, Belgium, Portugal, etc.).
A fix should be very urgently distributed since presently no one can release an Android application securely accessing these cards.
For information we work are Spirtech, an engineering company, expert in the fields of smart cards, cryptography and contactless technology (ISO 14443) which is currently developing several applications on Android, using its NFC features, for major public transport companies in Europe and in the world.