https://bugs.freedesktop.org/show_bug.cgi?id=51022
Bug #: 51022
Summary: Print range lost on file save/reopen if the file
contains external link
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.5.4 release
Platform: Other
OS/Version: Windows (All)
Status: NEW
Severity: major
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
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.
--
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
