Description: When I print only a specified range of records from the data source, I get strange page ranges to be printed. I have a single page Writer document and a Calc table with three records as the data source. Here is what I get for different record ranges: From To Result 1 1 Prints the document filled with data from first record. Fine. 2 2 Prints document with data from *third* record! 3 3 Error message: No pages to be printed available (I am translating from German 1 3 Prints all three pages. Fine. 2 3 Prints document with data from *third* record only! I looked into mmresultdialogs.cxx but could not find anything wrong that would be obvious to me. Maybe someone can help. Comment: I get the impression that Writer first generates an output document with all pages from all data source records and then prints a page range from this output document. Shouldn't it be better to generate an output document only for the selected data source record range and then print all of that document? Steps to Reproduce: 1. Open attached Writer document and connect to attached Calc data source 2. Push "Serienbrief drucken" (print merged document??) button 3. Select a record range as described above Actual Results: Incorrect ranges of the data source are output or an error is flagged as described above Expected Results: The Writer document should be printed for the specified range of data source records. Reproducible: Always User Profile Reset: Yes OpenGL enabled: Yes Additional Info: For the attachment, please get it from here: https://bugs.documentfoundation.org/show_bug.cgi?id=116527 User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64; rv:59.0) Gecko/20100101 Firefox/59.0
No repro with Version: 5.4.0.0.alpha1+ Build ID: 9feb7f7039a3b59974cbf266922177e961a52dd1 CPU threads: 4; OS: Windows 6.29; UI render: default; Locale: nl-NL (nl_NL); Calc: CL
I installed LO 6.0.2.1 and reproduced the bug there. Version: 6.0.2.1 (x64) Build ID: f7f06a8f319e4b62f9bc5095aa112a65d2f3ac89 CPU threads: 2; OS: Windows 10.0; UI render: default; Locale: de-DE (de_DE); Calc: group
Does this also happen with "Save merged document"?
(In reply to Buovjaga from comment #3) > Does this also happen with "Save merged document"? No. Works fine for me (LO 6.0.2.1). When you save e.g. from 0 to 0, it doesn't save anything. And LO doesn't complain about the illegal record numbers. There is only a small nit I would pick with the naming of the generated files: The appended sequence numbers should be 1-based as in the GUI and not 0-based.
Ok, I repro with MS print to PDF. In mail merge wizard, select address list - add - Test.ods to make the initial test case. I used "2 to 2" range. I bisected this to (I tried searching Bugzilla, no other bisection for this): https://cgit.freedesktop.org/libreoffice/core/commit/?id=3c1a343f6936f1dcefdf79a677f8c26ce29676e6 commit 3c1a343f6936f1dcefdf79a677f8c26ce29676e6 (patch) tree 1e8a21c764ec489381d6d9c63dacba12e029cbe9 parent dfbc2f37207f11a3bafb2c5ce0dea4fcc137e527 (diff) tdf#89708 Adjust print page range for unprinted blank pages Depending on whether automatically inserted blank pages are to be printed or not, the range of pages to print is expressed differently to the pages displayed in the preview in the Print dialog - i.e. the page range includes blank pages, whereas the preview doesn't (if blank pages are not to be printed). This patch adapts the range so that if blank pages are ignored upon printing, the range can be expressed across printable pages only, same as the Print dialog preview. An example is a merged document of several records into a single page letter or document - blanks are automatically put in between documents but usually aren't displayed/printed. Previously, printing page 2 would print the blank page between the 1st and 2nd merged document. After this change, printing page 2 will print the 2nd merged document instead. The "Pages" (print range) text box in the Print dialog defaults to the current page - this patch adjusts this when blanks are not to be printed so that it is expressed as the current page minus any blanks since the start of the document. Change-Id: Ic1d4d374a82c6f921bb41a97130838757c6b74b1 Reviewed-on: https://gerrit.libreoffice.org/18420 Adding jmux to CC as Eilidh is not contributing anymore.
Looks like you are on the right track. When I turn on "Print automatically inserted blank pages", it works as expected. All ranges of source records can be printed - of course with blank pages in between. The problem described above occurs for me only when the blank page option is not checked.
(In reply to muesliflyer from comment #6) > Looks like you are on the right track. When I turn on "Print automatically > inserted blank pages", it works as expected. All ranges of source records > can be printed - of course with blank pages in between. The problem > described above occurs for me only when the blank page option is not checked. Hmm, that was not me, but just quoting straight from the commit message. Maybe it is not a bug. Jmux can reveal the truth.
I don't repro. I tried with Output: Printer. (In reply to muesliflyer from comment #4) > There is only a small nit I would pick with the naming of the generated > files: The appended sequence numbers should be 1-based as in the GUI and not > 0-based. One issue per bug. And that's Bug 109120.
https://gerrit.libreoffice.org/55756
Mike Kaganski committed a patch related to this issue. It has been pushed to "master": http://cgit.freedesktop.org/libreoffice/core/commit/?id=cc46e7b9c75ddbcaaefde5f396ba76b0b866fa58 tdf#116537: use page #s excluding empty pages when they are ignored It will be available in 6.2.0. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Mike Kaganski committed a patch related to this issue. It has been pushed to "libreoffice-6-1": http://cgit.freedesktop.org/libreoffice/core/commit/?id=240cd3e2de7446fb009f7e372da28698aeb2682d&h=libreoffice-6-1 tdf#116537: use page #s excluding empty pages when they are ignored It will be available in 6.1.0.1. The patch should be included in the daily builds available at http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: http://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.