Bug 94373 - Serial letter function in Writer ignores lines in Calc sheet used as database
Summary: Serial letter function in Writer ignores lines in Calc sheet used as database
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Linux (All)
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Mail-Merge
  Show dependency treegraph
Reported: 2015-09-20 09:17 UTC by do.weller
Modified: 2017-05-07 09:11 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

94373 (92.76 KB, application/gzip)
2015-09-21 15:36 UTC, do.weller

Note You need to log in before you can comment on or make changes to this bug.
Description do.weller 2015-09-20 09:17:21 UTC
Could be related to 76257

When using a Calc sheet as a database Writer ignores the second line when printing ODTs in single-file-mode.

Furthermore, one has to specifically tell Writer which entries to print if you choose single-file-mode and PDF as output file type. If one chooses "all", Writer only prints the first DB-entry - but for every line in the DB.

Tested on Ubuntu 14.04.3 64bit
Comment 1 Buovjaga 2015-09-21 08:33:31 UTC
Please attach all example files so we can test.

Change back to UNCONFIRMED after you have provided the files.
Comment 2 do.weller 2015-09-21 13:59:53 UTC
The DB contains personal data - I cannot post it here in public. I would send them to you directly PGP encrypted but wasn't able to find your Key / any key for "Beluga"s E-Mail address (checked on https://pgp.mit.edu/).

Could you please let me know how and where to obtain your key?
Comment 3 Buovjaga 2015-09-21 14:15:56 UTC
You could anonymize the data and provide such a version: https://wiki.documentfoundation.org/QA/Bugzilla/Sanitizing_Files_Before_Submission#Sanitize_file_text
Comment 4 do.weller 2015-09-21 15:36:51 UTC
Created attachment 118906 [details]

I tried (and hopefully succeeded in doing so) ....
Comment 5 Buovjaga 2015-09-22 11:01:42 UTC
Nothing is ignored in my single file ODT and PDF tests.
All the 5 entries from the ODS get included.
In the PDF the first entry is not repeated.
Everything is like in the ODT.

Perhaps I need to test this on Linux as well.

For some reason you have included multi-file outputs in folders 1run_as-pdf_BUG and 2run_as-odt_WORKS. What are they supposed to demonstrate?

Win 7 Pro 64-bit, Version: (32-bit)
Build ID: 81898c9f5c0d43f3473ba111d7b351050be20261
Locale: fi-FI (fi_FI)
Comment 6 Buovjaga 2015-09-24 06:37:56 UTC
Everything ok in Linux as well.

Kubuntu 15.04 64-bit KDE Plasma 5.4
Build ID: 00m0(Build:2)
Locale: en-US (en_US.UTF-8)
Comment 7 Alex Thurgood 2016-06-15 08:46:51 UTC
@do.weller : please update your version of LibreOffice to the latest current production release, and report back as to whether you are still experiencing the same issue. At the moment, no one else was able to reproduce your problem.

Setting needinfo
Comment 8 QA Administrators 2017-05-02 11:36:44 UTC Comment hidden (obsolete)
Comment 9 do.weller 2017-05-07 09:03:14 UTC
Seems to be resolved. I haven't had the problem in a while ...