Bug 156952 - Mail merge puts extra page at save as individual documents (steps in comment 12)
Summary: Mail merge puts extra page at save as individual documents (steps in comment 12)
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Writer (show other bugs)
Version:
(earliest affected)
7.6.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Mail-Merge
  Show dependency treegraph
 
Reported: 2023-08-27 20:27 UTC by Piotr Osada
Modified: 2023-10-12 18:05 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Attachments
CV (11.86 MB, application/vnd.oasis.opendocument.text)
2023-08-27 20:27 UTC, Piotr Osada
Details
List.ods (13.53 KB, application/vnd.oasis.opendocument.spreadsheet)
2023-08-27 20:28 UTC, Piotr Osada
Details
bug_156952-1_save_merged_documents.png (202.74 KB, image/png)
2023-08-27 20:29 UTC, Piotr Osada
Details
2_Single_vs_separate_PDFs (433.93 KB, image/png)
2023-08-27 20:31 UTC, Piotr Osada
Details
Single doc (387.72 KB, application/pdf)
2023-08-27 20:38 UTC, Piotr Osada
Details
One of individual docs (83.22 KB, application/pdf)
2023-08-27 20:38 UTC, Piotr Osada
Details
Etykiety (labels mode) (32.66 KB, application/vnd.oasis.opendocument.text)
2023-08-27 21:55 UTC, Piotr Osada
Details
Narzędzia0.odb (8.10 KB, application/vnd.sun.xml.base)
2023-08-27 21:56 UTC, Piotr Osada
Details
Print all Labels by Microsoft Print to PDF.png (242.30 KB, image/png)
2023-08-27 21:56 UTC, Piotr Osada
Details
Print all Labels.pdf (216.61 KB, application/pdf)
2023-08-27 21:56 UTC, Piotr Osada
Details
Save Merged Documents ('print' result) (493.14 KB, image/png)
2023-09-11 16:24 UTC, Piotr Osada
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Piotr Osada 2023-08-27 20:27:09 UTC
Created attachment 189174 [details]
CV

Using attached files: CV.odt and List.ods in mail merge mode: Save Merged Documents → Save as a single document.
No mater if we choose PDF or ODT, unwanted extra additional page will be inserted at the end of the document.
This does not happen with a single large document, as it supposed to be, as well for individual documents.
This does not happen with a single large document, as it should also with single documents.
Comment 1 Piotr Osada 2023-08-27 20:28:30 UTC
Created attachment 189175 [details]
List.ods

Spreadsheet of names and addresses.
Comment 2 Piotr Osada 2023-08-27 20:29:52 UTC
Created attachment 189177 [details]
bug_156952-1_save_merged_documents.png

Steps to reproduce.
Comment 3 Piotr Osada 2023-08-27 20:31:37 UTC
Created attachment 189178 [details]
2_Single_vs_separate_PDFs

Actual result and system information:

Version: 7.6.0.3 (X86_64) / LibreOffice Community
Build ID: 69edd8b8ebc41d00b4de3915dc82f8f0fc3b6265
CPU threads: 4; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: pl-PL (pl_PL); UI: en-US
Calc: threaded
Comment 4 Piotr Osada 2023-08-27 20:38:21 UTC
Created attachment 189179 [details]
Single doc

Single doc is clear.
Comment 5 Piotr Osada 2023-08-27 20:38:58 UTC
Created attachment 189180 [details]
One of individual docs

Unwanted additional page.
Comment 6 Piotr Osada 2023-08-27 21:54:17 UTC
Similar behavior we have in "Labels" mode. When printing all labels into single document via MS Print to PDF (I have not checked printing on paper).


Attachments:
Etykiety.odt
Narzędzia0.odb
Print all Labels by Microsoft Print to PDF.png
Print all Labels.pdf
Comment 7 Piotr Osada 2023-08-27 21:55:45 UTC
Created attachment 189183 [details]
Etykiety (labels mode)
Comment 8 Piotr Osada 2023-08-27 21:56:02 UTC
Created attachment 189184 [details]
Narzędzia0.odb
Comment 9 Piotr Osada 2023-08-27 21:56:16 UTC
Created attachment 189185 [details]
Print all Labels by Microsoft Print to PDF.png
Comment 10 Piotr Osada 2023-08-27 21:56:30 UTC
Created attachment 189186 [details]
Print all Labels.pdf
Comment 11 Dieter 2023-09-09 15:31:20 UTC
(In reply to Piotr Osada from comment #2)
> Created attachment 189177 [details]
> bug_156952-1_save_merged_documents.png
> 
> Steps to reproduce.

Piotr, I'm sorry, but I can't see steps to reproduce here. Please make them more clear:
1. Open attachment 189174 [details]
2. Tools -> Mail Merge Wizard ??????
....

Thank you

=> NEEDINFO
Comment 12 Piotr Osada 2023-09-11 15:37:28 UTC
(In reply to Dieter from comment #11)
> => NEEDINFO

STEPS TO REGISTER AND LINK DATABASE

1) Open CV.odt (attachment 189174 [details])
2) Edit -> Exchange Database... ->
3) Under 'Available Databases' section, click: 'Browse...' -> select "List.ods" file (attachment 189175 [details]) and click 'Open'
4) Once again, 'Available Databases' section -> 'List' database -> select 'Arkusz1' sheet -> and click 'Define' button.


STEPS TO REPRODUCE BUG

As in screenshot "bug_156952-1_save_merged_documents.png" (attachment 189177 [details]):
1) Click 'Save Merged Documents' in the additional database toolbar.
2) Choose 'Save as individual documents'.
3) Click the 'Save Documents' button.
4) Save as PDF.

Result:
PDF has an additional blank page with footer (the same for ODT).


Other issues:
Saving as a single large document produces PDF with 7 pages (that's how it should be), and ODT with also 7 pages, but the page counter displays an overall number of 13 pages.
Comment 13 Piotr Osada 2023-09-11 16:24:24 UTC
Created attachment 189499 [details]
Save Merged Documents ('print' result)

1) It looks like there is an unwanted paragraph (BLANK TEXT showed in navigator).

2) And the second thing is that after export by 'Save merged documents' paragraph is changed by LO without our knowledge to have page break.

3) Third thing is that exported documents by 'Save merged documents' are still linked with the database of 'mother document'/'mail merge document'. 
In my humble opinion, these documents should be unlinked. That is my intention of saving as separate documents (that they become independent).
Comment 14 QA Administrators 2023-09-13 03:17:33 UTC Comment hidden (obsolete)
Comment 15 Dieter 2023-10-12 18:05:27 UTC
I confirm it with steps from comment 12 and

Version: 7.6.2.1 (X86_64) / LibreOffice Community
Build ID: 56f7684011345957bbf33a7ee678afaf4d2ba333
CPU threads: 4; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: zh-TW (de_DE); UI: en-GB
Calc: CL threaded

Additional information
Saving as a single large document gives correct result.
Saving as individual odt-documents gives also wrong result