Jan 03 2019 01:49 PM
Jan 03 2019 01:49 PM
I'm using a handheld scanner (Symbol DS3578) that is connected via bluetooth to Excel on an iPad Air 2. I have the scanner setup to append a return key (basically pressing the Enter/Return key) to the end of each scan to eliminate the need to interact with the iPad screen between scans simply to get to the next cell. I need to rapidly scan in short numbers (1-3 digits) into thousands of cells, however it appears that something is causing Excel to exit “Edit Mode” prematurely, truncating the number scanned. It doesn’t do this consistently which leads me to believe there may be some sort of race condition involved. I've tried increasing the intra-keystroke delay on the scanner to the maximum with no observable effect. Removing the return suffix eliminates the problem but forces the user to tap the green checkmark button to commit the cell or tap return on the iOS software keyboard after each scan, which is incredibly inefficient.
May 31 2019 08:13 AM
I am having the same problem. I have an iPad 5th Gen and a Teemi TMCT10. I notice that other apps, such as Word on Notes on iOS seem to have no problem reading from my barcode scanner. It must be something with the Excel iOS app.
Aug 27 2020 11:22 AM - edited Aug 27 2020 11:28 AM
I've had the same problem, the scanner typing the codes too quickly for excel to process. I have honeywell xenon 1902, which has configurable typing rate, so I set it slower and now excel is handling it well.
I have looked at manual for your scanner and found the same setting. It's "HID Keyboard Keystroke Delay" on page 63. After setting it you should see the scanned codes being typed slower. If not, try disconnecting the scanner or turning it off and on again.
Aug 30 2020 05:50 AM
Apr 05 2022 07:56 AM
@kevdougful I have a similar issue where when upc is scanned with handheld scanner it does not populate the entire code. I have tried the setting of ultra low speed with no success and sporadically it does capture the whole code. any suggestions on what to try would be greatly appreciated.