Bug 55631

Summary: FILEOPEN: CALC does not import DBASE with CP850 encoding correctly
Product: LibreOffice Reporter: tbb
Component: SpreadsheetAssignee: Not Assigned <libreoffice-bugs>
Status: NEW --- QA Contact:
Severity: normal    
Priority: medium CC: fdbugs, robert, todventtu
Version: 3.5.0 RC1Keywords: regression
Hardware: Other   
OS: All   
Whiteboard: bibisected
i915 platform: i915 features:
Attachments: Testfile dBase. Try to import with LO-Calc - works up to LO 3.4.6, doesn't since 3.5

Description tbb 2012-10-04 16:09:39 UTC
German umlauts are not decoded correcly.

Cross checked with OOo 3.2.1: It works.
Comment 1 robert 2013-02-03 19:51:11 UTC
I could confirm this bug. If you try to import a dBase-file to Calc, the filter-Dialog appears. You could choose the filter but it doesn't work.
Have tried this with LO 3.4.6 and the first LO 3.5.0 rc1. The bug first appears with LO 3.5 - in LO 3.4.6 and all earlier versions the import works right.
I have set the version to the version where the bug appears first.
The bug isn't solved up to LO 4.0.0.1.
Comment 2 robert 2013-02-03 19:54:58 UTC
Created attachment 74151 [details]
Testfile dBase. Try to import with LO-Calc - works up to LO 3.4.6, doesn't since 3.5

The dialog for Import DBase-files shows "Western Europe(DOS/OS2-850/International)". This import-filter doesn't work in Calc since 3.5. In earlier versions it works.
Comment 3 Beluga 2014-10-22 05:20:15 UTC
Western Europe(DOS/OS2-437/US) imports them correctly. Win 7 64-bit 4.3.2.2.
Comment 4 robert 2014-10-22 06:14:02 UTC
(In reply to Beluga from comment #3)
> Western Europe(DOS/OS2-437/US) imports them correctly. Win 7 64-bit 4.3.2.2.

You are right. It is possible to import it this way. But the original code is IBM850. So the filter starts correctly with "DOS/OS2 850 international" but couldn't import it with this filter.
Opened the file with AOO and "DOS/OS2 850 international" - right coding.
Opened the file with KWrite (Linux/KDE) and changed to IBM850 - right coding.
It also works right in the first LO-versions with "DOS/OS2 850 international".

There seems to be something wrong with the filter. LO recognizes the right filter automatically as OOo and AOO does, but could be the filter isn't linked internal the right way.
Comment 5 Urmas 2014-10-22 09:33:26 UTC
It's interesting: that encoding works fine on the files with (V)FP codepage mark.
Comment 6 Matthew Francis 2014-12-04 02:10:49 UTC
In bibisect-43all:

d202b17d88ecb0b608d81518624021c832c7dfdb is the first bad commit
commit d202b17d88ecb0b608d81518624021c832c7dfdb
Author: Bjoern Michaelsen <bjoern.michaelsen@canonical.com>
Date:   Wed Apr 25 07:28:24 2012 +0200

    source-hash-ce97851773a06103504972eb2771eecd7dd81e36
    
    commit ce97851773a06103504972eb2771eecd7dd81e36
    Author:     David Tardon <dtardon@redhat.com>
    AuthorDate: Mon Feb 6 19:12:02 2012 +0100
    Commit:     David Tardon <dtardon@redhat.com>
    CommitDate: Mon Feb 6 19:12:02 2012 +0100
    
        fix typo

:100644 100644 e1c1d62aa980fee004430f920cdbe3fd1ce79bf0 9acf11b8f6f5e26b03649767813ac42f72c38e1b M	autogen.log
:100644 100644 c14237a7b6ebde67a83585c9b057c78710e08ea2 db4232175b715b6c7f322b17041f56a9145e1622 M	ccache.log
:100644 100644 c407d12366338584cbcebf2197cd7fcdcf1c522b 1b83a94159f8aa22e004b5dc2ebe1895b32a2724 M	commitmsg
:100644 100644 3be616510b5296b5ae2f5c154a6c51f7ba49bf24 cc9f341a09ba536bb41d4219c5b7f5dd219d7cc6 M	dev-install.log
:100644 100644 637e789a93608b99c13fec9e598c2e7a4c454c6d 08ab33c46c34b7b9b0f8b7f21161ad1c1a2ed59a M	make.log
:040000 040000 c47ba9e6977c3c8a957b11ec3f8b85cfa50362af f87831ea583aaccb888e681ce264cc1e4e44d3aa M	opt

# bad: [423a84c4f7068853974887d98442bc2a2d0cc91b] source-hash-c15927f20d4727c3b8de68497b6949e72f9e6e9e
# good: [65fd30f5cb4cdd37995a33420ed8273c0a29bf00] source-hash-d6cde02dbce8c28c6af836e2dc1120f8a6ef9932
git bisect start 'latest' 'oldest'
# bad: [e02439a3d6297a1f5334fa558ddec5ef4212c574] source-hash-6b8393474974d2af7a2cb3c47b3d5c081b550bdb
git bisect bad e02439a3d6297a1f5334fa558ddec5ef4212c574
# bad: [8f4aeaad2f65d656328a451154142bb82efa4327] source-hash-1885266f274575327cdeee9852945a3e91f32f15
git bisect bad 8f4aeaad2f65d656328a451154142bb82efa4327
# bad: [369369915d3582924b3d01c9b01167268ed38f3b] source-hash-45295f3cdceb4c289553791071b5d7f4962d2ec4
git bisect bad 369369915d3582924b3d01c9b01167268ed38f3b
# good: [351622aec2dff3cc3bbbb020ad0097c4322d2a21] source-hash-2c4537471c932b65e6f72e41881b505c4bbad12c
git bisect good 351622aec2dff3cc3bbbb020ad0097c4322d2a21
# bad: [378efb6e51212a05d1bd4b85c916eec5753c1744] source-hash-d453788ac0476cc02b929b0907718ca771d6d956
git bisect bad 378efb6e51212a05d1bd4b85c916eec5753c1744
# bad: [1a3c4b54a8782fe0f4bdba221e87012a92e4d323] source-hash-a330f38093e2643a26239557050561afae9ff23d
git bisect bad 1a3c4b54a8782fe0f4bdba221e87012a92e4d323
# good: [cf86b7f14a98d2d81a5cd93507acb35ff6775d8b] source-hash-85c6244b85b29c1d2bb9d89b62e9512dd65378b5
git bisect good cf86b7f14a98d2d81a5cd93507acb35ff6775d8b
# good: [bc87fae0fc661b44769d71e41a0e8ce3dac3e857] source-hash-f176c9ba7be7f3051a52b9f57b56124038c0cfd6
git bisect good bc87fae0fc661b44769d71e41a0e8ce3dac3e857
# bad: [d202b17d88ecb0b608d81518624021c832c7dfdb] source-hash-ce97851773a06103504972eb2771eecd7dd81e36
git bisect bad d202b17d88ecb0b608d81518624021c832c7dfdb
# good: [9300cbe83880d09cc6d581eb73a92f35f3456b31] source-hash-43c7830b03d141ae11d8617c0fdabefa32dd243c
git bisect good 9300cbe83880d09cc6d581eb73a92f35f3456b31
# first bad commit: [d202b17d88ecb0b608d81518624021c832c7dfdb] source-hash-ce97851773a06103504972eb2771eecd7dd81e36

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.