https://bugs.documentfoundation.org/show_bug.cgi?id=138856
--- Comment #6 from Nicu Buculei <[email protected]> --- 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. -- You are receiving this mail because: You are the assignee for the bug.
