Handheld Barcode Scanner with Excel for iOS

%3CLINGO-SUB%20id%3D%22lingo-sub-308664%22%20slang%3D%22en-US%22%3EHandheld%20Barcode%20Scanner%20with%20Excel%20for%20iOS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-308664%22%20slang%3D%22en-US%22%3E%3CP%3EI'm%20using%20a%20handheld%20scanner%20(Symbol%20DS3578)%20that%20is%20connected%20via%20bluetooth%20to%20Excel%20on%20an%20iPad%20Air%202.%20I%20have%20the%20scanner%20setup%20to%20append%20a%20return%20key%20(basically%20pressing%20the%20Enter%2FReturn%20key)%20to%20the%20end%20of%20each%20scan%20to%20eliminate%20the%20need%20to%20interact%20with%20the%20iPad%20screen%20between%20scans%20simply%20to%20get%20to%20the%20next%20cell.%20I%20need%20to%20rapidly%20scan%20in%20short%20numbers%20(1-3%20digits)%20into%20thousands%20of%20cells%2C%20however%20it%20appears%20that%20something%20is%20causing%20Excel%20to%20exit%20%E2%80%9CEdit%20Mode%E2%80%9D%20prematurely%2C%20truncating%20the%20number%20scanned.%26nbsp%3B%20It%20doesn%E2%80%99t%20do%20this%20consistently%20which%20leads%20me%20to%20believe%20there%20may%20be%20some%20sort%20of%20race%20condition%20involved.%26nbsp%3B%20I've%20tried%20increasing%20the%20intra-keystroke%20delay%20on%20the%20scanner%20to%20the%20maximum%20with%20no%20observable%20effect.%26nbsp%3B%20Removing%20the%20return%20suffix%20eliminates%20the%20problem%20but%20forces%20the%20user%20to%20tap%20the%20green%20checkmark%20button%20to%20commit%20the%20cell%20or%20tap%20return%20on%20the%20iOS%20software%20keyboard%20after%20each%20scan%2C%20which%20is%20incredibly%20inefficient.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-308664%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1616987%22%20slang%3D%22en-US%22%3ERe%3A%20Handheld%20Barcode%20Scanner%20with%20Excel%20for%20iOS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1616987%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F260186%22%20target%3D%22_blank%22%3E%40kevdougful%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI've%20had%20the%20same%20problem%2C%20the%20scanner%20typing%20the%20codes%20too%20quickly%20for%20excel%20to%20process.%20I%20have%20honeywell%20xenon%201902%2C%20which%20has%20configurable%20typing%20rate%2C%20so%20I%20set%20it%20slower%20and%20now%20excel%20is%20handling%20it%20well.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1621467%22%20slang%3D%22en-US%22%3ERe%3A%20Handheld%20Barcode%20Scanner%20with%20Excel%20for%20iOS%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1621467%22%20slang%3D%22en-US%22%3EThe%20xenon%20has%20also%20interfuncion%20delay%20(for%20the%20return%20key%20and%20others).%20Check%20if%20your%20scanner%20supports%20configuring%20the%20return%20key%20for%20CR%2FLF%2FCR%2BLF%2C%20that%20might%20have%20an%20effect%20on%20the%20excel%20app.%3CBR%20%2F%3E%3CBR%20%2F%3EBy%20the%20way%20You%20should%20have%20not%20edited%20the%20post%20but%20made%20a%20new%20one.%3C%2FLINGO-BODY%3E
Occasional Visitor

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.

3 Replies

@kevdougful 

 

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.

 

 

@kevdougful 

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.

https://www.zebra.com/content/dam/zebra_new_ia/en-us/manuals/barcode-scanners/ds3578-prg-en.pdf

The xenon has also interfuncion delay (for the return key and others). Check if your scanner supports configuring the return key for CR/LF/CR+LF, that might have an effect on the excel app.

By the way You should have not edited the post but made a new one.