https://bugs.documentfoundation.org/show_bug.cgi?id=145358
Bug ID: 145358
Summary: Dynamic QR / Barcode creation using spreadsheet cell
reference
Product: LibreOffice
Version: 7.2.2.2 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: enhancement
Priority: medium
Component: LibreOffice
Assignee: [email protected]
Reporter: [email protected]
Description:
Presently QR code can be "Inserted" from Menu. There are some updates going on
at Library level for generating QR / BAR CODES [ Ref -
https://bugs.documentfoundation.org/show_bug.cgi?id=139778 ] as seen from " Bug
139778 - Switch to ZXing-C++ library for generating QR codes "
But all these methods require manual typing of the individual QR code text and
then insert it in document. This is not comfortable for REAL use where whole
list of texts needs to be converted dynamically in individual QR / Barcodes
Is it possible in generate QR code dynamically using sheet cell reference ?
There is similar project "Barcody". The original 2013 version by Jiri Gabriel
contained files for LibreOffice and MSOffice
Its uses code from -
http://stackoverflow.com/questions/16143331/generating-2d-pdf417-or-qr-barcodes-using-excel-vba/31663859#31663859
Also enclosing working barcody.ods vervion of sample file which demonstrates
the functionality I was describing.
But this rendering of QR/ Barcodes needs to create custom formula / function
and is not easy for average user to easily integrate it in the working
document.
So now if Libreoffice has already got the IN-BUILT ability to generate QR
Barcode, We must further extend it's function to use it directly through some
spreadsheet formula or BASIC library in MACRO.
If its done, it can be a great help to everyone.
Steps to Reproduce:
Every barcode text needs to type individually from Insert--> Object --> QR
Code.
Then we have to manually move the QR code image to required position.
Actual Results:
It generates QR / Bar codes but not in a useful bulk
Expected Results:
We should get Barcodes dynamically based on text appearing in the specified
cells and also QR Code need to get placed in the cells specified
Reproducible: Always
User Profile Reset: No
Additional Info:
Please see attachment Barcody.ods for demo of the unction required.
--
You are receiving this mail because:
You are the assignee for the bug.
