Issue 97216 - Import CSV with UTF8-BOM stream position problem
Summary: Import CSV with UTF8-BOM stream position problem
Status: CLOSED DUPLICATE of issue 89314
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 3.0
Hardware: All All
: P5 (lowest) Trivial (vote)
Target Milestone: ---
Assignee: ooo
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-12-12 19:01 UTC by stonkie
Modified: 2013-08-07 15:13 UTC (History)
1 user (show)

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

Attachments
The file which shows the problem. Look at the first cell in the top left corner and you will see it still has double quotes surrounding it. (484 bytes, text/csv)
2008-12-12 19:05 UTC, stonkie 		no flags Details
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 stonkie 2008-12-12 19:01:48 UTC 
I'm developping an application that passes around a CSV file in UTF8 format with
the ';' value delimiter (so it open on Excel for our customers). I tried opening
it in Calc (I must choose UTF8 character set and check the ';' delimiter) and it
leaves the double quotes that means it's a Text value, but only for the very
first cell (so the cell values can contain the character used as delimiter in
the file). 

I do not know what could cause this, maybe an error parsing the first character
or something to do with UTF8. I will attach the file that shows the problem.
Comment 1 stonkie 2008-12-12 19:05:36 UTC 
Created attachment 58785 [details]
The file which shows the problem. Look at the first cell in the top left corner and you will see it still has double quotes surrounding it.
Comment 2 ooo 2008-12-17 13:51:23 UTC 
Looks like this is due to the <ef bb bf> UTF8-BOM that seems not to be handled
correctly by the stream positioner.
Comment 3 niklas.nebel 2010-10-05 15:21:48 UTC 
Isn't this the same as issue 89314?
Comment 4 ooo 2010-10-05 19:42:25 UTC 
Yes, it is.

*** This issue has been marked as a duplicate of 89314 ***
Comment 5 ooo 2010-10-05 19:43:07 UTC 
Closing dup.