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