Bug 78008 - Calc update or calculation problems with Excel 97-2003 xls files
Summary: Calc update or calculation problems with Excel 97-2003 xls files
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: LibreOffice (show other bugs)
Version:
(earliest affected)
4.2.3.3 release
Hardware: All All
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2014-04-27 17:51 UTC by Tor24_1975314
Modified: 2015-02-12 21:34 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Example files and files to compare (33.04 KB, application/zip)
2014-04-27 17:51 UTC, Tor24_1975314 		Details
View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
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