1) To create labels from a spreadsheet, the spreadsheet must first be exported to csv or dbf. 2) After selecting the (say) dbf file the fields from another database are presented and the required fields must be swapped with them. 3) To suppress blank fields the menu item Insert|Section must be used for reach one.
Why is there not dedicated labels workflow window that allows any source, selects all fields, has a simple checkbox for suppress empty fields? This is the most complicated thing many users ever want to do. I have introduced many people to LibreOffice, but many have gone back to MS Office at Christmas, when they are doing their Christmas cards.
Steps to Reproduce:
1.Create a spreadsheet with titled label columns
2.Follow instructions to create a label - export to csv or dbf file
3.Create labels and insert sections to suppress blank fields
Usually failure when entering sections to suppress blanks.
Reversion to manual editing or using gLabel.
Much easier process without jumping around the menu.
User Profile Reset: No
OpenGL enabled: Yes
See MS Office or gLabel for better workflow.
User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:57.0) Gecko/20100101 Firefox/57.0
Yep, it is a bit convoluted. Here is a video tutorial for reference: https://www.youtube.com/watch?v=7n8Psg8yxPE
Thanks for the youtube video. I had already seen it plus a lot of other web snippets, the best being from OpenOffice.
It does not fix the problem that producing labels for the first time requires several hours just to understand those convolutions that you mention. I think you could create a TV show to see who could do it the fastest on the first attempt.
I would recommend glabel rather than any video, until the workflow is made simple and transparent.
*** Bug 114578 has been marked as a duplicate of this bug. ***
(In reply to Buovjaga from comment #1)
> Yep, it is a bit convoluted. Here is a video tutorial for reference:
If it used to do this but no longer does it, this is a bug in current LibreOffice. I attempted the same steps in the video, but was unable to recreate the results in version 220.127.116.11.
I will try again with the latest update, and report back.
(In reply to bignintyfan from comment #4)
> (In reply to Buovjaga from comment #1)
> > Yep, it is a bit convoluted. Here is a video tutorial for reference:
> > https://www.youtube.com/watch?v=7n8Psg8yxPE
> If it used to do this but no longer does it, this is a bug in current
> LibreOffice. I attempted the same steps in the video, but was unable to
> recreate the results in version 18.104.22.168.
> I will try again with the latest update, and report back.
I just tried with version 22.214.171.124. It does work correctly; however, only the first entry actually shows up in the document.
I suspect that two different things may be confused here. One is labels - many sets of fields on a single sheet of paper. The other is mailmerge - one set of fields on many documents.
I was able to produce a sheet of labels, with a different address on each label. However, I could not omit blank fields.
I have not tried mailmerge.