Ask Your Question
0

QR Code Generator

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

Geoffrey-Comf gravatar image

Hi,

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.

Cheers

Geoffrey

edit retag flag offensive close merge delete

Comments

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 goqr.me 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
1

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: https://gitlab.com/mauriciobaeza/zaz-...

C:\fakepath\ask.gif

edit flag offensive delete link more

Comments

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
0

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

Opaque gravatar image

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

Hello,

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

Comments

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

2 followers

Stats

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

Seen: 428 times

Last updated: Apr 23