Description: Hello, I created a simple ods named data, a single sheet tb1 with Field1, Field2 and Field3 field1 field2 field3 a 1 ! b 2 @ c 3 # And then I used it in a writer doc: Num: <Record number:data.tb1> Field1: <data.tb1.field1> Field 2: <data.tb1.field2> Field 3: <data.tb1.field3> Num: <Record number:data.ods> Field1: <data.tb1.field1> Field 2: <data.tb1.field2> Field When I generate the final doc, I do get the right output: Num: 1 Field1: a Field2: 1 Field3: ! Num: 2 Field1: b Field2: 2 Field3: @ <new page> Num: 3 Field1: c Field2: 3 Field3: # But when I'm editing it and select a record using the maildirect toolbar, I get: Num: 1 Field1: a Field2: 1 Field3: ! Num: 1 Field1: Field2: Field3: ! With record number repeating the last one used and all other fields empty. Steps to Reproduce: 1. Create any mail merge doc with two records per page 2. see the problem Actual Results: I cannot preview the multiple records Expected Results: It should look like the final output when I merge the records Reproducible: Always User Profile Reset: Yes Additional Info: Reproduced with version 7.3 as well.
Created attachment 187717 [details] The editing file
Created attachment 187718 [details] Simple database
Created attachment 187719 [details] The final output (which is correct) The issue is while editing the main file
I missed something during ctrl+c/ctrl+v. The text is like this (There is a "Next Record"): Num: <Record number:data.tb1> Field1: <data.tb1.field1> Field 2: <data.tb1.field2> Field 3: <data.tb1.field3> <Next Record: data.tb1> Num: <Record number:data.ods> Field1: <data.tb1.field1> Field 2: <data.tb1.field2> Field 3: <data.tb1.field3> The uploaded files were fine.
Luiz, thank you for reporting the bug. Unfortunatelay nobody could confirm it for more than six month. I only can test with Windows and I'm not familiar with mailmerge, so I need a proper set of steps. I've started with the following steps: 1. Download attachment 187718 [details] 2. Open attachment 187717 [details] 3. Select a field -> Edit -> Fields 4. Add database file -> Add downloaded file "data.ods" 5. ??? Could you please complete the steps? thank you => NEEDINFO
3. Edit the first field (Record Number) "Num: <double click or right click/edit fields> Field1:..." 4. Add database file -> Add downloaded file "data.ods" 5. Select the table from data->tb1 Now you can use the "Mail Merge" toolbox to navigate between records. At first, you'll be at record -1 (because you were missing the database at start). When you select the first record, you'll get (# means empty field): Num: # Field1: a Field2: 1 Field3: ! Num: 1 Field1: # Field2: # Field3: # While it should be: Num: 1 Field1: a Field2: 1 Field3: ! Num: 2 Field1: b Field2: 2 Field3: @ Now we have multiple issues: 1) The field we edited (record number or any other) seems to be broken, although it is the same as the one in the second line (if you show field names with ctrl+f9). If we copy the one from the second line, over it, it works as expected. If we duplicate it, the copy is kept broken 2) The record number after the "Next Record:data.tb1" is still 1 while it should be 2 3) All other fields in the second line are empty during edition but they do work while merging the doc 4) If you reload this file a couple of times, LibreOffice frequently crashes.
Luiz, thank you for further steps. But unfortunately I can't change the mail merge entry. It's alwys -1. Don't know what I did wrong. I hope somebody else can help.
(In reply to Dieter from comment #7) > Luiz, thank you for further steps. But unfortunately I can't change the mail > merge entry. It's alwys -1. Don't know what I did wrong. I hope somebody > else can help. You just need to navigate to the next record. It is the arrow pointing to the right, the one right to the -1 textbox in the mail merge toolbox.
Sorry for late replay, but I can't confirm it: Steps 1. Download attachment 187718 [details] 2. Open attachment 187717 [details] 3. Select first field -> Edit -> Fields 4. Add database file -> Add downloaded file "data.ods" 5. OK 6. In Mail Merge Toolbar use arrows to navigate between the different Mail Merge Entries Actual and expected result: Num: 1 Field1: a Field2: 1 Field3: ! Num: 2 Field1: b Field2: 2 Field3: @ Num: 3 Field1: c Field2: 3 Field3: # Version: 24.8.0.0.alpha1+ (X86_64) / LibreOffice Community Build ID: d2eab48f697a1e6097778158f623f11306ac7a3d CPU threads: 4; OS: Windows 10 X86_64 (10.0 build 19045); UI render: Skia/Raster; VCL: win Locale: de-DE (de_DE); UI: en-GB Calc: CL threaded Luiz, could you please retest wit actual version? => NEEDINFO
Dear Luiz Angelo Daros de Luca, This bug has been in NEEDINFO status with no change for at least 6 months. Please provide the requested information as soon as possible and mark the bug as UNCONFIRMED. Due to regular bug tracker maintenance, if the bug is still in NEEDINFO status with no change in 30 days the QA team will close the bug as INSUFFICIENTDATA due to lack of needed information. For more information about our NEEDINFO policy please read the wiki located here: https://wiki.documentfoundation.org/QA/Bugzilla/Fields/Status/NEEDINFO If you have already provided the requested information, please mark the bug as UNCONFIRMED so that the QA team knows that the bug is ready to be confirmed. Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-NeedInfo-Ping
Dear Luiz Angelo Daros de Luca, Please read this message in its entirety before proceeding. Your bug report is being closed as INSUFFICIENTDATA due to inactivity and a lack of information which is needed in order to accurately reproduce and confirm the problem. We encourage you to retest your bug against the latest release. If the issue is still present in the latest stable release, we need the following information (please ignore any that you've already provided): a) Provide details of your system including your operating system and the latest version of LibreOffice that you have confirmed the bug to be present b) Provide easy to reproduce steps – the simpler the better c) Provide any test case(s) which will help us confirm the problem d) Provide screenshots of the problem if you think it might help e) Read all comments and provide any requested information Once all of this is done, please set the bug back to UNCONFIRMED and we will attempt to reproduce the issue. Please do not: a) respond via email b) update the version field in the bug or any of the other details on the top section of our bug tracker Warm Regards, QA Team MassPing-NeedInfo-FollowUp