Ask Your Question

QR Code Generator

asked 2020-04-23 05:41:10 +0200

Geoffrey-Comf gravatar image


My first question, on this forum, so here goes. In Calc, can I add a cell reference to the QR Code generator to create QR codes dynamically?

eg. in the URL/Text: =B2

to pick up the data in cell B2.



edit retag flag offensive close merge delete


What is "the QR code gemerator" for you?
Please have in mind that none of us is knowing your system / install / extensuons.

Lupp gravatar imageLupp ( 2020-04-23 13:45:49 +0200 )edit

@Lupp - it's not an externsion but a new feature of LibreOffice 6.4 - see LibreOffice 6.4: Release Notes - Core / General

Opaque gravatar imageOpaque ( 2020-04-23 13:49:25 +0200 )edit

Tanks! Sorry. Had missed the new feature. Of course, this implies that I haven't yet any related knowledge.

Lupp gravatar imageLupp ( 2020-04-23 13:52:19 +0200 )edit

A bit of investigation semmed to show that the new feature isn't yet accessible via an API service, and that the needed proceedings cannot be automated with the help of a recorded macro.
Thus I can only tell that shapes have a property .Description where probably the source cell (as its AbsoluteName?) could be stored withouit endangering different functionality Another automate might then check the QR codes contained in the document for needing updates. To also automate the update itself seems impossible currently.

Lupp gravatar imageLupp ( 2020-04-23 19:46:36 +0200 )edit

hey Geoffrey, did you solve this problem? I am looking for a solution too. Cheers

leszke gravatar imageleszke ( 2020-06-26 14:36:13 +0200 )edit

I did not find anything, but it seems LibreOffice uses api, so the creation of the codes via simple script (could be bash or node.js if you will) should be easily done. I will be certainly creating one soon

leszke gravatar imageleszke ( 2020-06-26 15:09:53 +0200 )edit

2 Answers

Sort by » oldest newest most voted

answered 2020-04-23 16:38:38 +0200

mauricio gravatar image

updated 2020-04-23 16:39:19 +0200

You can used my extension Zaz-BarCode:


edit flag offensive delete link more


Sorry, but ZAZ-BaCode is not good for this - not able to specify cell for generate - selected cell only. Data from selected cells is not calculated - your plugin make qr code formula instead of result of calculation.

nothing75 gravatar imagenothing75 ( 2020-06-02 09:37:01 +0200 )edit

answered 2020-04-23 12:26:30 +0200

Opaque gravatar image

updated 2020-04-23 13:33:25 +0200


no - you can't. Use a QR reader and see that you'd get the text "=B2"

[Update] Obviously my statement above is not clear enough: "Use a QR reader and see that you'd get the text "=B2"**" is meant as a means how to check what you get from generating QR code using Insert -> Object -> QR Code...

edit flag offensive delete link more


The question wasn't about a QR-reader, but about generating QR-codes.

Lupp gravatar imageLupp ( 2020-04-23 13:20:38 +0200 )edit

@Lupp - probably you misunderstood that. It's just a hint how to check that generating QR-codes with LibreOffice creates QR code with text only and for that a QR reader is required (I can't read QR code without such tool).

Opaque gravatar imageOpaque ( 2020-04-23 13:26:36 +0200 )edit
Login/Signup to Answer

Question Tools



Asked: 2020-04-23 05:41:10 +0200

Seen: 428 times

Last updated: Apr 23