https://bugs.freedesktop.org/show_bug.cgi?id=75671
Priority: medium
Bug ID: 75671
Assignee: [email protected]
Summary: FILESAVE After open a xls and save as xls the linked
cells in formula get linked to wrong cells and so show
wrong results
Severity: critical
Classification: Unclassified
OS: Linux (All)
Reporter: [email protected]
Hardware: All
Status: UNCONFIRMED
Version: 4.2.1.1 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 94961
--> https://bugs.freedesktop.org/attachment.cgi?id=94961&action=edit
3 example files as described in the Description of the bug
I have found this problem after destroying some calculations with many linked
sheets using Libre Office 4.2.0.4.
After open the xls file I did some small change (wrote a comment in a cell) and
save it again as xls. Next time I open the file I found all calculations get
wrong. After it I found the formulas get wrong only just after saving the file
again as XLS.
This problem was available also in Libre Office 4.2.0.4 but there after save
the formula get broken when open it open again with Libre Office 4.1.5.3 and
also with Libre Office 4.2.0.4.
Now with Libre Office 4.2.1.1 if same file get saved as XLS it got broken
formulas if open again with Libre Office 4.2.1.1 but looks OK when open with
Libre Office 4.1.5.3.
I believe the reason for the problems must be some cells manipulations done by
Libre Office 4.2.x during the save process, resulting in broken formulas.
Please see the attached Zip file.
There are available 3 files.
1. The original file - Created_by_LibreOffice-4.5.1.xls
2. Result_after_save_by_LibreOffice-4.2.0.xls
3. Result_after_save_by_LibreOffice-4.2.1.1.xls
If you fry to open the file Result_after_save_by_LibreOffice-4.2.1.1.xls with
Libre Office 4.5.1 calculations inside will look OK, but if open it with Libre
Office 4.2.1.1 they will look wrong.
--
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
