Description: 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 Actual Results: Usually failure when entering sections to suppress blanks. Reversion to manual editing or using gLabel. Expected Results: Much easier process without jumping around the menu. Reproducible: Always User Profile Reset: No OpenGL enabled: Yes Additional Info: 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: > 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 5.4.3.2. 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 5.4.3.2. > > I will try again with the latest update, and report back. I just tried with version 5.4.4.2. 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.
I just used mail merge to address envelopes with LO 7.0.2 in Linux Mint 20. It works perfectly. It would be improved if the fields displayed using the data immediately hid the blank lines. I thought the 'Don't show blank lines' checkbox had no effect and spent an hour looking for a method of suppressing them. I decided to print to file as a single file and saw that blank line suppression had been working all the time.
(In reply to Mike Sapsard from comment #7) > I just used mail merge to address envelopes with LO 7.0.2 in Linux Mint 20. > It works perfectly. ... saw that blank line suppression had been working all the time. Great. Resolving this issue as NAB/WF.
(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 Right, BUT this video does NOT show how to deal with blank lines, which is the KEY POINT!!!