Bug 78008

Summary: Calc update or calculation problems with Excel 97-2003 xls files
Product: LibreOffice Reporter: Tor24_1975314
Component: LibreOfficeAssignee: Not Assigned <libreoffice-bugs>
Status: RESOLVED FIXED    
Severity: major CC: cno, Tor24_1975314
Priority: medium    
Version: 4.2.3.3 release   
Hardware: All   
OS: All   
Whiteboard:
Crash report or crash signature: Regression By:
Attachments: Example files and files to compare

Description Tor24_1975314 2014-04-27 17:51:58 UTC
Created attachment 98087 [details]
Example files and files to compare

In some cases the update or calculations of formulas within Excel 97-2003 xls files are wrong!
This behavior was found in all LibreOffice Calc 4.2.x versions (Calc 4.2.0 up to 4.2.3)!

The same example files work correctly with Libre Office 3.6.x, 4.0.x and 4.1.x  (Tested with Calc versions 3.6.5, 4.0.4 and 4.1.4)

(By the way: The frame format export from Calc 4.2.3 to Excel xls and xlsx files seems also to have a problem. The example files are created with Calc 4.2.3. Open these files in Excel 2000 and check the frame style!)

See attached example xls file. Compare also with .ods and .xlsx example files!
Comment 1 Cor Nouws 2014-05-01 22:26:03 UTC
Hi tor,

Thanks for reporting - I see the problem is solved in 4.2.4.1, so it is fixed in the mean time.
Regards,
Cor
Comment 2 Tor24_1975314 2014-05-03 20:02:19 UTC
I tested this bug also with the pre-release of version 4.2.4.1 and can confirm this bug seems to be fixed!

Regards,
Tor24