CODEWITHSUNDEEP
excelbartender
Harun24hr
Harun24hr

Reputation: 36870

How to create multiline QR code using bartender?

I am trying to generate multiline QR code in Bartender. I am using excel file as data source and take 3 filed for testing first. It successfully generate QR code but when I scan all text shows in a single line but I want it to be in 3 fiend in 3 separate line. I have used Carriage Return control character <<CR>> after 1 data field. Below is QR code properties settings.

enter image description here

When I scan the QR Code image then it gives me following output.

No_LAN_IP90:61:AE:BC:5B:01FAC-Laptop-044

My Expected output is

No_LAN_IP
90:61:AE:BC:5B:01
FAC-Laptop-044

Any help is greatly appreciated.

I have Tagged the post as Excel because I am using excel file as data source. May be someone excel expert may know the fact.

Upvotes: 0

Views: 7614

Answers (1)

Wouter
Wouter

Reputation: 61

Using LF (Line Feed) instead of CR should solve the problem.

--edit--

After rereading your problem I saw I missed something. You are using the example data field to add a LF which will not be used while printing. In the properties screen you have a tab "Transforms" which has an option to add a suffix and/or prefix. If you put the LF in the suffix field for your first and second line your problem should be solved.

Upvotes: 1

Related Questions