In case of documents that contain linked data (things like ='file:///C:/path/file.ods'#$Sheet1.A1) option 'Print' produces empty prints for sheets 13 or higher. Print does work fine for sheet 1 up to sheet 12.
It happens for Linux and Windows.
Steps to Reproduce:
I'm using Polish version of LO.
1. Create Calc document and in Sheet1 fill cells A1 to A13 with values 1 to 13.
2. Save the file and close the app.
3. Create another calc document and add 12 sheets so that there are 13 sheets all together.
4. Go back to first sheet and in cell A1 enter ='file:///C:/path/first_file.ods'#$Sheet1.A1
5. In second sheet in cell A1 enter ='file:///C:/path/first_file.ods'#$Sheet1.A2. Repeat the process for remaining sheets replacing A2 with A3, A4,...
6. Save second file and close the app
7. Reopen second file, allow loading external content, go to sheet 13 and hit "Print Preview" <- bug there is nothing in the preview (in my case "Empty print range" but in Polish "Pusty zakres wydruku"). Also Print doesn't print anything
Empty 'Pring preview', empty paper sheet
A13 printed on paper
User Profile Reset: Yes
If second file is saved in Excel file format then 'Print preview' is working correctly
Wersja: 220.127.116.11 (x64)
Build ID: 60da17e045e08f1793c57c00ba83cdfce946d0aa
Wątki CPU: 8; OS:Windows 10.0; UI render:domyślny; VCL: win;
Ustawienia regionalne: pl-PL (pl_PL); Język interfejsu: pl-PL
Bibisected with win32-5.0 to https://git.libreoffice.org/core/+/bfa4494560884635a03c4db89588a118f9a2be0b%5E!/
Adding Cc: to Stephan Bergmann
Note: having an example attachment would not be of use. The second file needs to be created anew every time (as I did with bibisecting). However, there is no need to paste anything into sheets 1-12. Just create enough sheets and use sheet 13.
(In reply to Buovjaga from comment #1)
> Bibisected with win32-5.0 to
So that's apparently win32-5.0 commit
Author: Norbert Thiebaud <firstname.lastname@example.org>
Date: Mon Jun 1 16:05:57 2015 -0500
However, if I check out its predecessor and follow the below reproducer recipe, it also shows the unexpected "Print Range Empty". Buovjaga, can you please verify that you bibisected correctly?
> Note: having an example attachment would not be of use. The second file
> needs to be created anew every time (as I did with bibisecting). However,
> there is no need to paste anything into sheets 1-12. Just create enough
> sheets and use sheet 13.
Blah, now I can't reproduce the issue with latest master on Windows or Linux!
Tomasz: can you please test with a fresh build: https://dev-builds.libreoffice.org/daily/master/current.html Win-x86_64@tb77-TDF?
I also realised my win32-5.0 result was bogus after retesting the first bad commit.
Stephan on IRC tells me he can reproduce the problem on Linux master, so I don't know which way is up anymore.
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:
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!
I confirm that I can't reproduce the issue with 18.104.22.168 on Windows!
So the problem is gone for me but was it fixed ? :)
I can still reproduce with Linux master, unfortunately
Arch Linux 64-bit
Build ID: 2764c334c3b9cf428e4e7ab0c28ce6a34036fa77
CPU threads: 8; OS: Linux 5.9; UI render: default; VCL: kf5
Locale: fi-FI (fi_FI.UTF-8); UI: en-US
Built on 2 November 2020
Created attachment 173948 [details]
Reproducer file made in 7.3 master per instructions
Created attachment 173949 [details]
The bug in LO 7.2 bibisect repo
How sheet 13 (what really mattered is that it was the last one) looked in print preview in the last bad version.
Created attachment 173950 [details]
Sheet 13 in the fixed version
Looks good now, since:
Thanks Attila for fixing this one too :)
*** This bug has been marked as a duplicate of bug 51022 ***