search

alitrack / barcode-vba-macro-only

Barcode generator for LibreOffice and MSOffice as pure VBA macro
MIT License
21 stars 41 forks source link

How I can change length text to generate QR Code #1

Open giggstae opened 6 years ago

giggstae commented 6 years ago

I load sample Excel but my data cannot generate full text

sample:

Text : ODH080014$OL1$PRM20H0013$Q34$LSTOREPC2$SRM1711200001 (in 1 line)

QR generate data only : ODH080014$OL1$PRM20H0013$Q34$LSTOREPC2$SRM

Please help suggest where the code I can change.

JonasHeidelberg commented 6 years ago

I think your problem might be related to the “stuttering“ I observed and fixed in my fork https://github.com/jonasheidelberg/barcode-vba-macro-only

Generally these problems are likely to have to do with switching the encoding within the QR code (in your case the switch from captial letters to numbers-only does not happen).

Could you check if my fork also shows your problem?

Best Jonas

Am 22.11.2017 um 11:36 schrieb giggstae notifications@github.com:

I load sample Excel but my data cannot generate full text

sample:

Text : ODH080014$OL1$PRM20H0013$Q34$LSTOREPC2$SRM1711200001 (in 1 line)

QR generate data only : ODH080014$OL1$PRM20H0013$Q34$LSTOREPC2$SRM

Please help suggest where the code I can change.

— You are receiving this because you are subscribed to this thread. Reply to this email directly, view it on GitHub, or mute the thread.

giggstae commented 6 years ago

I download sample excel file follow this picture.

If I incorrect, please share a correct link.

question

and this is my file image

JonasHeidelberg commented 6 years ago

You are right, the error you had was different from the one I fixed in February. Sorry for that! The code generating the eb() array is just deeply broken, I'd love to be able to talk to the original author to at least understand it better, this would greatly simplify debugging.

I will upload a quickfix for your problem in a few minutes. I hope this covers all use cases that you have, but I cannot be sure the code is now bug-free, because I don't have the time to set up a serious testing suite and/or rewrite the buggy code completely.

giggstae commented 6 years ago

It's work.

Thank you very much.