Bug 40801 - Incorrect import of MS Excel File, lost numbers
Summary: Incorrect import of MS Excel File, lost numbers
Status: RESOLVED FIXED
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
Master old -3.6
Hardware: All Windows (All)
: high critical
Assignee: Markus Mohrhard
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: mab3.5
  Show dependency tree / graph
 
Reported: 2011-09-12 04:55 UTC by esperantisto
Modified: 2011-10-31 17:02 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Source XLS file (17.50 KB, application/vnd.ms-excel)
2011-09-12 04:55 UTC, esperantisto 		Details
File as imported by LibO dev-3.5 (10.21 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-09-12 04:56 UTC, esperantisto 		Details
File as imported by LibO 3.4.3 (10.62 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-09-12 04:56 UTC, esperantisto 		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 esperantisto 2011-09-12 04:55:41 UTC 
Created attachment 51070 [details]
Source XLS file

In the daily builds of LibO dev-3.5 dated 2011-09-06 and 2011-09-12 (taken from http://dev-builds.libreoffice.org/daily/Windows_XP_SP3/master/), some Microsoft Excel files (XLS) are imported incorrectly with numbers zeroed. Found in MS Windows 7 Pro. Attaching a test case: a source XLS file, a file as imported by dev-3.5 and a file as imported by 3.4.3 (correct import, all numbers are OK).
Comment 1 esperantisto 2011-09-12 04:56:22 UTC 
Created attachment 51071 [details]
File as imported by LibO dev-3.5
Comment 2 esperantisto 2011-09-12 04:56:55 UTC 
Created attachment 51072 [details]
File as imported by LibO 3.4.3
Comment 3 esperantisto 2011-09-12 04:58:19 UTC 
> In the daily builds of LibO dev-3.5 dated 2011-09-06 and 2011-09-12

Sorry, the latter build tested was of 2011-09-10, not of 2011-09-12.
Comment 4 Markus Mohrhard 2011-09-15 16:29:38 UTC 
set correct version
Comment 5 Markus Mohrhard 2011-10-28 04:19:02 UTC 
it is an annoying bug, also breaks sc's filters-test on windows

windows only bug, but looses several cell entries during import

see also sc/qa/unit/data/xls/matrix.xls and sc/qa/unit/data/xls/formats.xls
Comment 6 Markus Mohrhard 2011-10-28 04:23:15 UTC 
it is only reproducable with a windows build or a mingw build

I hope that I'll be able to get a debug build soon, so that I can have a look into it
Comment 7 Petr Mladek 2011-10-31 03:17:42 UTC 
This looks pretty annoying. I add Kohei into CC to put it on his radar as well.
Marcus, if you could fix it, it would be great.
Comment 8 Markus Mohrhard 2011-10-31 16:49:51 UTC 
I think I found the problem and I think I know why that is a windows only problem.

Seems to be the result of some refactoring in the SvStream code. Will push a fix soon.
Comment 9 Markus Mohrhard 2011-10-31 17:02:01 UTC 
fixed with http://cgit.freedesktop.org/libreoffice/core/commit/?id=125aa32e71eb9a8de6214a7f7bc3e3be13b14a7a

tested with a mingw build