I started creating labels getting data from a calc file (via Base of course). After working on the file and making some (good) test prints, it stars behaving weirdly, printing one page for each DB record filled with the data from a single DB entry. So, it starts working good and then stops, and show this problem. From this moment on cannot get it back to work, even saving, closing, restarting pc ... The only way is to create a new file (until it stops working too)
This bug is very random, since sometimes labels work fine and other don't, even in the same file. But when they stop working, they won't come back again and only a new file has the chance to work again. Anyone uning labels out there?
Which LibO version are you using? What operating system? You can search for other label bugs by looking for label in the summary: https://bugs.documentfoundation.org/query.cgi?format=advanced Set product to LibreOffice, component to Printing & PDF export and Resolution to ---
Versione: 5.0.2.2 Build ID: 00m0(Build:2) Versione locale: it-IT (it_IT.utf8) on Debian GNU/Linux stretch/sid I'll have a look at other bugs reports as you suggested, thanks! :)
So, no one has tried this? It's a very blocking bug, and now the bug from random has become "stable", as I cannot use the Labels tool neither on Linux nor on Windows. Debian GNU/Linux amd64 Version: 5.0.5.1 Build ID: 00m0(Build:1) Locale: it-IT (it_IT.utf8) Windows 7 Versione: 5.0.4.2 Build ID: 2b9802c1994aa0b7dc6079e128979269cf95bc78 Versione locale: en-GB (it_IT)
Could you attach some example files so people are more likely to test?
Created attachment 122480 [details] Test files test files
Ok, here's an example. The tar.bz2 I've uploaded contains: an ods (the addressbook) an odb (needed, to be used as data source) two odt: one is the template to be filled with the data and the other is the result of the mail merge printed as file
I must add a detail: the first time I've created the labels it all went fine. But after saving the file, changed DB, changed back to the original the bug showed up. Of course I'm not sure that all this changes affect the behavior, I've just reported what have happened.
Here's a video about the procedure, hope it's clear enough https://hub.mrjive.eu/cloud/mrjive/etichette.ogv
(In reply to Davide Pesenti from comment #8) > I must add a detail: the first time I've created the labels it all went fine. > But after saving the file, changed DB, changed back to the original the bug > showed up. Did like you said, but I didn't get the repeating John Doe. I tried both in 5.0.4 and 5.2. Win 7 Pro 64-bit, Version: 5.0.4.2 (x64) Build ID: 2b9802c1994aa0b7dc6079e128979269cf95bc78 Locale: fi-FI (fi_FI) Version: 5.2.0.0.alpha0+ Build ID: 76ec54e8c9f3580450bca85236a4f5af0c328588 CPU Threads: 4; OS Version: Windows 6.1; UI Render: default; TinderBox: Win-x86@39, Branch:master, Time: 2016-02-09_00:10:35 Locale: fi-FI (fi_FI)
As I said, sometimes works, but after some time (save? close/open? I don't know) stops working. If you saw the video that's exactly what happens. Both linux and windows.
The behavior is correct. What you're missing the insertion of the special field "Next record". You can find it in the Database tab of the "Insert => Field => More Fields… (Ctrl + F2). Just add it to the end of the content of your label. Otherwise the record set is just advanced per document, so you get three pages for you three entries, all with the same record entries. AFAIK this was never different. Probably there are some generated labels, which insert the field automatically - don't know.
Well that is new to me. I used to use labels (always the same custom label model for years) this exact way. It it was a wrong method it would never have worked, I guess. Moreover the guide here https://help.libreoffice.org/Common/Creating_and_Printing_Labels_and_Business_Cards does not talk about inserting "next record"
Excuse me, why is it not a bug?
Because Jan-Marek said so. In any case, the correct status is not FIXED.
With all the due respect, I really doubt that what he said, that is you need to add the "next record" field, is either the solution or the correct procedure. I also posted a link to the Libreoffice official help that makes no mention of this. Is someone here using this feature in everyday work? Thanks for your comprehension and attention!
(In reply to Davide Pesenti from comment #16) > With all the due respect, I really doubt that what he said, that is you need > to add the "next record" field, is either the solution or the correct > procedure. In which older version was it working like you describe? You can test older versions: http://downloadarchive.documentfoundation.org/libreoffice/old/ https://wiki.documentfoundation.org/Installing_in_parallel/Linux
(In reply to Beluga from comment #17) > (In reply to Davide Pesenti from comment #16) > > With all the due respect, I really doubt that what he said, that is you need > > to add the "next record" field, is either the solution or the correct > > procedure. > > In which older version was it working like you describe? > You can test older versions: > http://downloadarchive.documentfoundation.org/libreoffice/old/ > https://wiki.documentfoundation.org/Installing_in_parallel/Linux I'll try to do that. In the meantime, can someone point out where the "next record" step is in the guide? I cannot find traces of that in neither in the online guide nor in the built-in help. Thanks
(In reply to Davide Pesenti from comment #18) > > I'll try to do that. > In the meantime, can someone point out where the "next record" step is in > the guide? I cannot find traces of that in neither in the online guide nor > in the built-in help. Thanks It is in the OpenOffice.org wiki for the OOo3 User guide : https://wiki.openoffice.org/wiki/Documentation/OOo3_User_Guides/Writer_Guide/Print_labels_from_db
Also note that if you chose to "Update your Links" at any stage (see link to OOo mailmarge label printing above), then you will have tied all of your label results to the first, or master label.