Bug 107896 - MAILMERGE : "Exchange database" misses "next record" fields
Summary: MAILMERGE : "Exchange database" misses "next record" fields
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (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: 2017-05-16 16:26 UTC by marc
Modified: 2019-03-25 08:04 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:

Mailmerge Document base (21.58 KB, application/vnd.oasis.opendocument.text)
2017-05-22 19:03 UTC, marc
Base database (31.36 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-05-22 19:04 UTC, marc
Second database (31.36 KB, application/vnd.oasis.opendocument.spreadsheet)
2017-05-22 19:05 UTC, marc
Mailmerge Document after changing database (21.94 KB, application/vnd.oasis.opendocument.text)
2017-05-22 19:06 UTC, marc

Note You need to log in before you can comment on or make changes to this bug.
Description marc 2017-05-16 16:26:11 UTC
Document is a set of stickers thus using "next record" field in all but the first box.
If I change source database using the "exchange database" from "Edit" Menu to a new one with a different registered name, e.g. "Catalogue1" to "Catalogue2", the "exchange database" recalculates all fields names to bind to Catalogue2. 
Catalogue1.table.field become Catalogue2.table.field
However, "Next Record:Catalogue1.table" remains "Next Record:Catalogue1.table".

Steps to Reproduce:
1. see description

Actual Results:  
Data fields are properly processed but not the "next record" field.
"Next Record:Catalogue1.table" remains "Next Record:Catalogue1.table".

Expected Results:
"Next Record:Catalogue1.table" should become "Next Record:Catalogue2.table".

Reproducible: Always

User Profile Reset: No but have it on several computers.

Additional Info:

User-Agent: Mozilla/5.0 (X11; Ubuntu; Linux x86_64; rv:53.0) Gecko/20100101 Firefox/53.0
Comment 1 Buovjaga 2017-05-22 16:35:02 UTC
Could you provide minimal document and database files so testers can test more efficiently?

Change back to UNCONFIRMED after you have provided the files.
Comment 2 marc 2017-05-22 19:03:31 UTC
Created attachment 133458 [details]
Mailmerge Document base
Comment 3 marc 2017-05-22 19:04:20 UTC
Created attachment 133459 [details]
Base database
Comment 4 marc 2017-05-22 19:05:12 UTC
Created attachment 133460 [details]
Second database

actually it's just a copy of the base database Catalogue.ods
Comment 5 marc 2017-05-22 19:06:28 UTC
Created attachment 133461 [details]
Mailmerge Document after changing database

"Catalogue" became "Catalogue2" for data fields but remained "Catalogue" for "Next records" fields.
Comment 6 Roman Kuznetsov 2018-06-14 19:21:31 UTC
Mike, please look at this bug
Comment 7 Dieter 2019-01-17 21:56:18 UTC
Marc, some new releases of LibreOffice are available since this bug was reported. Could you please try to reproduce it with the latest version of LibreOffice from https://www.libreoffice.org/download/libreoffice-fresh/ ?I have set the bug's status to 'NEEDINFO'. Please change it back to 'UNCONFIRMED' if the bug is still present in the latest version.
Comment 8 marc 2019-03-09 18:39:59 UTC
I confirm the bug is still there in both : my regular install : snap install

sorry for the late reply.
Comment 9 Buovjaga 2019-03-24 17:00:03 UTC
marc: can you explain in more detail, how we should test with your attached files?

Here are my steps so far:
1. Open Stickers.odt
2. Edit - Exchange database - Browse - Catalogue.ods
3. Edit - Exchange database - Browse - Catalogue2.ods

Now what should I look at? I see the Next record fields are the empty grey blocks at the top of Auteur fields, but how can I confirm this: "Next Record:Catalogue1.table" remains "Next Record:Catalogue1.table"
Comment 10 marc 2019-03-24 21:33:48 UTC
Sorry, I forgot to mention that you should enable Menu / View / "Field Names" to actually see that the database reference part changes for all fields but the "Next Record".

So full scenario should be
1. Open Stickers.odt
2. enable View / "Field Names"
3. Edit - Exchange database - Browse - Catalogue.ods
4. Edit - Exchange database - Browse - Catalogue2.ods
Comment 11 Buovjaga 2019-03-25 08:04:14 UTC
Thanks, now I was able to confirm.

Arch Linux 64-bit
Build ID: 66b21521a95f7b2053aa99a23e0a4c34438af6c7
CPU threads: 8; OS: Linux 5.0; UI render: default; VCL: gtk3; 
Locale: fi-FI (fi_FI.UTF-8); UI-Language: en-US
Calc: threaded
Built on 22 March 2019