Reproduced with LibreOffice 3.4.5, 3.5.4 on XP and Win 7. It worked fine with OpenOffice.org 3.2.1 and 3.3.0. If a Calc file contains an external link, print range at last sheet is lost when saved and reopened. And as I stated, whether the file has 2 sheets, 3 sheets or 10 sheets, only the last sheet of the document is affected by this bug. It can be reproduced with a new document, and reproducible everytime. Steps to reproduce: 1. Create 2 new Calc files. (A.ods, B.ods) 2. Open A.ods and enter a data into A1 of Sheet1 and save. 3. Open B.ods and insert an external link at A1 of Sheet 1 to refer the data entered to A.ods at step 2. 4. Enter data to the remaining sheets of B.ods so all sheets have print range each. 5. Save B.ods, close and reopen. 6. Print range at last sheet is lost. If I open the file saved at the above step 5 with OO 3.2.1 and 3.3.0, the print range is ok. And if I save the file at the above step 6, then open it with OO, the print range isn't loaded. Therefore LO CAN save the print range, however, CAN NOT load it when reopened. (Overwrite the file at this point will permanently loses it.) Also, if I set the print range again with LO, it is lost again when reopened. But then it starts working fine if the link is removed. Here are the work-arounds I have found so far, but I don't think these are all that practical. -Insert a blank sheet at the end of the document. (Hide the blank sheet if needed.) -If a file has a sheet that does not need to be printed, move this sheet to the end of the document.
Another case to point out. Use Excel to create an xls file with the same steps as comment 1. But this time, insert the link to Sheet 2.(Make sure Sheet1 has just some plain texts w/o any links) And save it while all sheets are set to normal view, open with LO and save as ods. Reopen the ods and LO does not lose the print range. If the xls is saved by using Excel while any of the sheets are in page preview mode, then the bug is reproduced. Also, if the link is set to the first sheet of the xls, the bug is reproduced regardless the view mode.
I did some further testing. The bug wasn't reproducible with versions 3.3.4 and earlier. However, newly created files with 3.4.0 could reproduce the bug. Therefore, whatever the change that was made between 3.3.4 and 3.4.0 may be the cause of this bug and that also means that all versions after 3.4.0 up to the latest version 3.5.4 would be affected. And files created with 3.3.4 and earlier were not affected even when opened with 3.4.0 and could also be overwritten w/o losing its print range.
One more thing I forgot to mention. The bug occurs if the print range is defined. Delete all the defined print range so that all cells with data entered would automatically be subject of printing, all sheets will keep its print range. Although I cannot recall at what version of LO starts off with defined range for the fresh sheet (As for an example, start a new Calc file with 3.5.4 and go to "Format" -> "Print Range" and you can see that "Delete" can be pressed. And it means that there is a defined print range even though it is a fresh sheet) This could also be a part of the cause to this bug, perhaps?
Now that I looked into it, new files created with versions 3.3.0 - 3.3.4 do not have a print range defined with fresh sheets. It looks like this predefined print range feature was first introduced with version 3.4.0. If I define a print range to a sheet with links using 3.3.4, then it is lost when opened with 3.4.0 and later versions. It worked fine when print ranges were defined to all sheets except for the sheet with links.
So it's been out there for six months now, has it not? Yes indeed this beetle is -quite- annoying. Running Libre Office 3.6.4.3 on an XP pro. Pentium 4 and the pest is still there... Thanks a lot to HD for the detailed reporting which provides with a temporary fix or so it seems: just add an empty sheet at the end of your project and the infectious insect loses all power to irritate.
The bug also exists on ubuntu 12.04 and libreOffice 3.5.7.2
This bug still exists in 4.2.4. Thanks to those who pointed out that it only applies to the last sheet, and therefore there is a workaround.
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present on a currently supported version of LibreOffice (5.0.4 or later) https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the version of LibreOffice and your operating system, and any changes you see in the bug behavior If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a short comment that includes your version of LibreOffice and Operating System Please DO NOT: - Update the version field - Reply via email (please reply directly on the bug tracker) - Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to "inherited from OOo"; 4b. If the bug was not present in 3.3 - add "regression" to keyword Feel free to come ask questions or to say hello in our QA chat: http://webchat.freenode.net/?channels=libreoffice-qa Thank you for your help! -- The LibreOffice QA Team This NEW Message was generated on: 2016-01-17
This bug still exist in LibreOffice 5.0.5 and it still only applies to the last sheet.
** Please read this message in its entirety before responding ** To make sure we're focusing on the bugs that affect our users today, LibreOffice QA is asking bug reporters and confirmers to retest open, confirmed bugs which have not been touched for over a year. There have been thousands of bug fixes and commits since anyone checked on this bug report. During that time, it's possible that the bug has been fixed, or the details of the problem have changed. We'd really appreciate your help in getting confirmation that the bug is still present. If you have time, please do the following: Test to see if the bug is still present with the latest version of LibreOffice from https://www.libreoffice.org/download/ If the bug is present, please leave a comment that includes the information from Help - About LibreOffice. If the bug is NOT present, please set the bug's Status field to RESOLVED-WORKSFORME and leave a comment that includes the information from Help - About LibreOffice. Please DO NOT Update the version field Reply via email (please reply directly on the bug tracker) Set the bug's Status field to RESOLVED - FIXED (this status has a particular meaning that is not appropriate in this case) If you want to do more to help you can test to see if your issue is a REGRESSION. To do so: 1. Download and install oldest version of LibreOffice (usually 3.3 unless your bug pertains to a feature added after 3.3) from http://downloadarchive.documentfoundation.org/libreoffice/old/ 2. Test your bug 3. Leave a comment with your results. 4a. If the bug was present with 3.3 - set version to 'inherited from OOo'; 4b. If the bug was not present in 3.3 - add 'regression' to keyword Feel free to come ask questions or to say hello in our QA chat: https://kiwiirc.com/nextclient/irc.freenode.net/#libreoffice-qa Thank you for helping us make LibreOffice even better for everyone! Warm Regards, QA Team MassPing-UntouchedBug
This bug is still present in Libreoffice 6.0.5.2 under Debian.
This bug still exists in LibreOffice 6.4.1 on Manjaro linux. The workaround really seems to be to append an empty sheet at last position.
Attila Szűcs committed a patch related to this issue. It has been pushed to "master": https://git.libreoffice.org/core/commit/bd6214e2aa6f25e013eef769529b75c1e3b580cb tdf#51022 sc import: fix lost print ranges of last sheet It will be available in 7.2.0. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
Attila Szűcs committed a patch related to this issue. It has been pushed to "libreoffice-7-1": https://git.libreoffice.org/core/commit/88476a6f89f2908fc8083dbbb53391b75192c783 tdf#51022 sc import: fix lost print ranges of last sheet It will be available in 7.1.1. The patch should be included in the daily builds available at https://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More information about daily builds can be found at: https://wiki.documentfoundation.org/Testing_Daily_Builds Affected users are encouraged to test the fix and report feedback.
*** Bug 77021 has been marked as a duplicate of this bug. ***
Verified in Version: 7.2.0.0.alpha0+ (x64) / LibreOffice Community Build ID: 44b914b1e2616ca8f70e896e653a46ca93610234 CPU threads: 4; OS: Windows 10.0 Build 17134; UI render: Skia/Raster; VCL: win Locale: hu-HU (hu_HU); UI: hu-HU Calc: threaded
*** Bug 137232 has been marked as a duplicate of this bug. ***
*** Bug 47592 has been marked as a duplicate of this bug. ***
*** Bug 129960 has been marked as a duplicate of this bug. ***