Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

barcody.bas won't encode numbers #4

Open
makulais opened this issue Dec 18, 2017 · 6 comments · Fixed by JonasHeidelberg/barcode-vba-macro-only#3
Open

barcody.bas won't encode numbers #4

makulais opened this issue Dec 18, 2017 · 6 comments · Fixed by JonasHeidelberg/barcode-vba-macro-only#3

Comments

@makulais
Copy link

If a number with no characters included in it is input as the string to be encoded, the QR gen file does not encode any value at all into the QR code. Tested with values of 0 - 65535, ... no value is encoded into the QR code. Tested with all ECL's, no value is encoded into the QR code. If a single character is included into the string, then the QR code will correctly implement the string, but if it is strictly numbers it will not.

@JonasHeidelberg
Copy link
Contributor

JonasHeidelberg commented Dec 21, 2017 via email

JonasHeidelberg added a commit to JonasHeidelberg/barcode-vba-macro-only that referenced this issue Dec 22, 2017
This fix addresses alitrack#4
Essentially, the original code failed to output ANY trailing numbers (probably an IF clause is missing in qr_gen() ). Previous commit fixed this for trailing multi-digit numbers, but not for single digits due to an off-by-one error.

NOTE: Excel file is not updated yet! Only the barcody.bas file has been fixed. (somehow github doesn't accept file uploads right now)
@JonasHeidelberg
Copy link
Contributor

Hi, actually my fork had already fixed this bug for inputs from 10-65535 three weeks ago. I now also fixed it for single-digit numbers - you can find the updated code here: https://github.com/JonasHeidelberg/barcode-vba-macro-only/commits/quickfix-witwall-issue-4/barcody.bas
Note you need to download the barcody.bas file - the XLSX is not updated yet. Hope this helps!

JonasHeidelberg added a commit to JonasHeidelberg/barcode-vba-macro-only that referenced this issue Dec 22, 2017
* Fix an off-by-one error in barcody.bas

This fix addresses alitrack#4
Essentially, the original code failed to output ANY trailing numbers (probably an IF clause is missing in qr_gen() ). Previous commit fixed this for trailing multi-digit numbers, but not for single digits due to an off-by-one error.
@JonasHeidelberg
Copy link
Contributor

... I now also updated the XLSX and merged into my Master https://github.com/JonasHeidelberg/barcode-vba-macro-only
Would love to hear if this solves your issue!

JonasHeidelberg added a commit to JonasHeidelberg/barcode-vba-macro-only that referenced this issue Dec 22, 2017
* Fix an off-by-one error in barcody.bas

This fix addresses alitrack#4
Essentially, the original code failed to output ANY trailing numbers (probably an IF clause is missing in qr_gen() ). Previous commit fixed this for trailing multi-digit numbers, but not for single digits due to an off-by-one error.
@makulais
Copy link
Author

makulais commented Dec 26, 2017 via email

@JonasHeidelberg
Copy link
Contributor

JonasHeidelberg commented Dec 26, 2017 via email

@kazu-kazu
Copy link

QR gen
If a comma is included in the number
It cannot be recognized correctly.
Please..

Example: In excel
555,0123456789,550,9999999999

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

Successfully merging a pull request may close this issue.

3 participants