Bug 58315

Summary:	FILEOPEN: LibreOffice looses formulas in XLS file.
Product:	LibreOffice	Reporter:	Olivier Hallot <olivier.hallot>
Component:	Spreadsheet	Assignee:	Not Assigned <libreoffice-bugs>
Status:	NEEDINFO ---	QA Contact:
Severity:	major
Priority:	medium
Version:	3.6.4.3 release
Hardware:	Other
OS:	All
Whiteboard:
i915 platform:		i915 features:

Description Olivier Hallot 2012-12-14 21:19:13 UTC

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

Comment 1 Jorendc 2012-12-14 21:38:17 UTC

I can reproduce

Mac OSX 10.8.2; LibreOffice 3.6.4.3 (Build ID: 2ef5aff)

Comment 2 foss 2014-08-25 10:43:36 UTC

Open test file, go to sheet "Fevereiro 2013" and there row 649.

For the field in question I do see value "1" and formula "=SUMME(D649)" in excel.

In LO 4.3.1 on OSX 10.9.4 I do see value "1" and formula "=$'BASE DADOS'.D612".

Not sure what to make of that. Olivier, can you test if this bug persists with LO 4.3.1?

Use of freedesktop.org services, including Bugzilla, is subject to our Code of Conduct. How we collect and use information is described in our Privacy Policy.