https://bugs.freedesktop.org/show_bug.cgi?id=58315
Priority: medium
Bug ID: 58315
Assignee: libreoffice-bugs@lists.freedesktop.org
Summary: FILEOPEN: LibreOffice looses formulas in XLS file.
Severity: major
Classification: Unclassified
OS: All
Reporter: olivier.hal...@documentfoundation.org
Hardware: Other
Status: UNCONFIRMED
Version: 3.6.4.3 release
Component: Spreadsheet
Product: LibreOffice
The file in the following link shows loss of excel formulas when openend in
LibreOffice above 3.3.
The file was Excel 2002, and was edited by Excel >2007 and saved back in xls.
The file opens and works correctly in Excel 2002.
Where are the loss of formulas: Please go to 'FEVEREIRO 2013'.R649. You will
see value 0.0, and formula #NAME?
The range R649:R656 is plenty of values with wrong formulas.
When saving in ODS format (and re-opening) the values now appears as #NAME?
To circumvent the issue, one has to edit manually the formula inside Excel
2002, forcing a new edition/update of the formula.
Please note the named formula SHARED_FORMULA_XX_YY_ZZ_WW, found in Insert ->
Names -> Define. These shared formulas are an indication of an Excel 2007 usage
(I guess).
http://wiki.documentfoundation.org/File:1.zip
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
