https://bugs.freedesktop.org/show_bug.cgi?id=42910
Bug #: 42910
Summary: [Calc] xls export corrupts some formulas with named
ranges
Classification: Unclassified
Product: LibreOffice
Version: LibO 3.4.3 release
Platform: Other
OS/Version: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Spreadsheet
AssignedTo: [email protected]
ReportedBy: [email protected]
Created attachment 53512
--> https://bugs.freedesktop.org/attachment.cgi?id=53512
Original.xls file (from MS Excel 2007)
When you open the attached Original.xls file in LibO Calc (3.4.3) and re-save
it as .xls (using "Save As...") some of the formulas that contain named ranges
produce Err:520.
--== Steps to reproduce ==--
1. Open attached file (Original.xls) in LibO
2. Select "File" -> "Save As... (Ctrl + Shift + S)"
3. Enter some file name (e.g. "Saved_as_xls.xls")
4. Click "Save" to confirm
5. Close LibO
6. Open newly saved file (e.g. "Saved_as_xls.xls")
Expected result: File should look exactly the same as the original.
Actual result: Some (not all) formulas containing named ranges produce Err:520,
specifically D8:E24.
--== End of reproduction ==--
Additional comments:
All the formulas in D6:E24 should contain the same formula (with updated
relative references). However, only D8:E24 produce the error (D6:E7 appear
fine).
The attached file "Original.xls" was created with MS Excel 2007. The names
have local scope (local to the sheet "Standard"). The file I attached is a
trimmed version of the file I noticed it with.
If the newly saved file (e.g. "Saved_as_xls.xls") is opened in Excel, it also
produces an error (#NAME?).
If original.xls is opened and saved to .ods, there is no problem.
Additionally, if that .ods file is opened and saved as .xls, there is also no
problem.
--
Using LibreOfficePortable 3.4.3 (as from portableapps.com)
Windows 7 Professional x64
About:
LibreOffice 3.4.3
OOO340m1 (Build:302)
--
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
