Summary: | Allow for input to QR-Code Generator by reference to another object | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | Michael <mhi> |
Component: | LibreOffice | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | enhancement | CC: | dennisroczek, gellert.gyuris, heiko.tietze, jrk33, mhi, pharmankur, robert-documentfoundation, samuel.mehrbrodt, vsfoote |
Priority: | medium | ||
Version: | 6.4.6.2 release | ||
Hardware: | All | ||
OS: | All | ||
See Also: |
https://bugs.documentfoundation.org/show_bug.cgi?id=128718 https://bugs.documentfoundation.org/show_bug.cgi?id=145358 |
||
Whiteboard: | |||
Crash report or crash signature: | Regression By: | ||
Bug Depends on: | |||
Bug Blocks: | 127232 |
Description
Michael
2020-12-12 14:28:36 UTC
I'm also relating to this - referring to the cell to create QR, would be really useful. What I'd need for my purpose would be some kind of formula so I could drag it and generate QR codes for a list of records (codes) (=QR_sth(CELL)). Would something like that be possible? I'm likewise connecting with this - alluding to the cell to make QR, would be truly helpful here https://wattinsider.com/best-4000-watt-generator/ What I'd require for my motivation would be some sort of recipe so I could drag it and generate QR codes for a rundown of records Could something to that effect be conceivable? This is the generic case of bug 145358 which is limited to barcode generated from content or formula result of a Calc cell. Here it is the more versatile ask for barcode source: "...a spreadsheet cell or a textbox or a label or some other persistent text-laden entity". +1 Commented on bug 145358 that adding a formula might not work on round-trip operations and is not (yet) defined by OASIS. Nevertheless such a feature is desirable and I'd go with =barcode(reference, type = <>). *** Bug 145358 has been marked as a duplicate of this bug. *** I stumbled upon this while researching for a solution I need at my workplace. The organization is doing a review for the whole inventory, from chairs and tables to computers and printers and every item will receive a sticker printed with its inventory number, in numeric format and as a barcode (preferably QR code, so it can hold more info). Thousands of items. Normally this is done with some specialized label printers and their proprietary software. We have a couple of such old printers and no software, just drivers. Data will be received probably as spreadsheets. The first idea was to use some barcode fonts to generate Code 128 or Code 39 barcodes, import spreadsheet data with Mail Merge and generate the labels. There are two problems with this: Code 128 and Code 39 can't hold as much data as QR and generated with fonts they are not as reliable (testing with my phone, they are really bad). A second approach was to use Zint (a cross platform, open source, code generator). Export spreadsheets to CSV, use a bash script and create codes from command line as PNG. Then do a Mail Merge to print the labels with data from the spreadsheet and images as external files. Unfortunately, LibreOffice can't use images in a Mail Merge (Microsoft Office can, but in a clunky and buggy way). Then LibreOffice has this limited code generator functionality. It may be useful when generating 1-2 codes per document, but not for 1000+ Something like =barcode(reference, type = <>) would be perfect but only if a) in Calc the image would be contained within a cell, not floating or b) in Writer if it can load the values dynamically from a source (as in my scenario, data source for mail merge). Hope this is useful as a description for an use case. Another use case: Recently the Spanish tax authorities have announced that starting in 2024 all invoices must include a QR code. Its exact content is still to be defined, but it will probably include the invoice number, date, etc. So having a dynamic way to generate a QR code from a formula would be really useful to support this use case. |