Issue 89314 - CSV import should recognize Unicode BOM
Summary: CSV import should recognize Unicode BOM
Status: CLOSED FIXED
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
URL:
Keywords: oooqa
: 97216 (view as issue list)
Depends on:
Blocks:
 
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: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

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.

example:
"Hallo","World"

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

but sometimes it import in cell A1:
"Hallo"
and in cell A2:
World

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 https://openoffice.org/bugzilla/attachment.cgi?id=58785 of issue 97216.