Issue 117612 - Improper csv parsing
Summary: Improper csv parsing
Status: CLOSED DUPLICATE of issue 78926
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: version58
Hardware: Mac Mac OS X 10
: P2 Normal (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-03-30 14:46 UTC by npardington
Modified: 2012-06-13 12:28 UTC (History)
1 user (show)

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

Attachments
This is the csv file in question. I've replace the letters so not to reveal sensitive information. (17.54 KB, text/plain)
2011-03-30 14:46 UTC, npardington 		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 npardington 2011-03-30 14:46:23 UTC 
The following file does not open correctly in Open Office, but does open in Microsoft Office.
Comment 1 npardington 2011-03-30 14:46:57 UTC 
Created attachment 76225 [details]
This is the csv file in question. I've replace the letters so not to reveal sensitive information.
Comment 2 ooo 2011-03-31 14:56:16 UTC 
Line 9 (record starting with 34) and line 11 (record starting with 41) contain unescaped quote characters. Apparently the one in line 11 confuses the field parser and records starting with 42 and 43 have their field contents misplaced. Workaround: let the generator write files that adhere to the CSV specification. To treat such broken files more relaxed there is issue 78926.

*** This issue has been marked as a duplicate of issue 78926 ***
Comment 3 Oliver-Rainer Wittmann 2012-06-13 12:28:30 UTC 
getting rid of value "enhancement" for field "severity".
For enhancement the field "issue type" shall be used.