Issue 89314 - CSV import should recognize Unicode BOM
Summary: CSV import should recognize Unicode BOM
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.3
Hardware: All All
: P3 Trivial (vote)
Target Milestone: 3.4.0
Assignee: ooo
QA Contact: issues@sc
Keywords: oooqa
: 97216 (view as issue list)
Depends on:
Reported: 2008-05-11 20:32 UTC by v_dirr
Modified: 2011-04-08 11:57 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description v_dirr 2008-05-11 20:32:43 UTC
import of the first cell of an cvs file can fail.


If you import this line, then it openOffice should remove testquotes.
so it should in cell A1:
and in cell A2:

but sometimes it import in cell A1:
and in cell A2:

So sometimes openOffice don't remove the textquotes from the first field.

i am able to reproduce this bug.

just save the csv file with UTF-8 and without Byte-Order Mark. then open office
import the first field correct.
then save the csv file with UTF-8 and with Byte-Order Mark. then openOffice
import the first field incorrect.

so the bug is, that open office don't import correct The Unicode Byte-Order Mark
(BOM) in UTF-8 encoded csv files.
Comment 1 Regina Henschel 2008-05-11 23:16:27 UTC
I can confirm the error for OOo3.0Beta on WinXP.

Another problem with this error is, that Writer sets a BOM, when saving text to
encoding UTF-8, which therefore will import wrong in Calc.
Comment 2 ooo 2008-05-29 18:14:57 UTC
Grabbing issue.
Comment 3 ooo 2008-05-29 18:15:30 UTC
Comment 4 ooo 2010-10-05 19:42:23 UTC
*** Issue 97216 has been marked as a duplicate of this issue. ***
Comment 5 ooo 2011-04-08 11:57:11 UTC
Fixed since DEV300_m101, for a test case file see also of issue 97216.