Created attachment 119408 [details] screenshot and example of *.wks to load Hello. Libre Office Calc incorrectly loads data from WKS-file (in attachment). See screenshot in attachment - all data in the column "barcode" are wrong. MS Office Excel 2003 loads this file correctly.
Confirmed. Works OK in 4.3.0.1, so regression. Win 7 Pro 64-bit, Version: 5.0.2.2 (x64) Build ID: 37b43f919e4de5eeaca9b9755ed688758a8251fe Locale: fi-FI (fi_FI) Version: 5.1.0.0.alpha1+ Build ID: f830600ece806ec365a4839e79afabe183c5e36d TinderBox: Win-x86@62-merge-TDF, Branch:MASTER, Time: 2015-10-06_22:49:09 Locale: en-US (fi_FI)
bibisect-win32-5.0, oldest version contains bug too. git checkout oldest: Version: 4.5.0.0.alpha0+ Build ID: 57d6b92b69a31260dea0d84fcd1fc5866ada7adb
I observe the same problem in 4.3 built with system libwps 0.3.1. So the bug first appeared in that version.
Created attachment 119666 [details] screenshot
Created attachment 119667 [details] sample spreadsheet
This seems to have begun at the below commit. Adding Cc: to Maxim Monastirsky ; Could you possibly take a look at this one? Thanks 9eb6d29a186b297c94553d17aeeba03bb58b0e75 is the first bad commit commit 9eb6d29a186b297c94553d17aeeba03bb58b0e75 Author: Matthew Francis <mjay.francis@gmail.com> Date: Sun Mar 15 00:09:55 2015 +0800 source-hash-e5ac048af125e82829d353ec031c99e96572e2c0 commit e5ac048af125e82829d353ec031c99e96572e2c0 Author: Maxim Monastirsky <momonasmon@gmail.com> AuthorDate: Sun Aug 3 15:51:51 2014 +0300 Commit: Maxim Monastirsky <momonasmon@gmail.com> CommitDate: Sun Aug 3 15:52:41 2014 +0300 Fix calc_MS_Works_Document extensions Change-Id: Icbf087464997561b09c7b43c2269eea2c8c603bb
(In reply to raal from comment #6) > This seems to have begun at the below commit. > commit e5ac048af125e82829d353ec031c99e96572e2c0 > Author: Maxim Monastirsky <momonasmon@gmail.com> > AuthorDate: Sun Aug 3 15:51:51 2014 +0300 > Commit: Maxim Monastirsky <momonasmon@gmail.com> > CommitDate: Sun Aug 3 15:52:41 2014 +0300 > > Fix calc_MS_Works_Document extensions > > Change-Id: Icbf087464997561b09c7b43c2269eea2c8c603bb What happened in this commit, is that the libwps based filter now loads the file instead of the LO internal lotus filter - which still loads the file correctly if forcing it (by selecting "Lotus 1-2-3" type in the open dialog).
Hello, concerning libwps, I find the cause of this problem of precision and I commit https://sourceforge.net/p/libwps/code/ci/394f21a421754d047f2802b8a2c13fbb44e593ff/ to fix it ( a fix which will happen in libwps-0.4.3 :-~ )