Issue 8599 - incorrect import of CSV file
Summary: incorrect import of CSV file
Status: CLOSED DUPLICATE of issue 7370
Alias: None
Product: Calc
Classification: Application
Component: code (show other issues)
Version: OOo 1.0.1
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords: oooqa
Depends on:
Blocks:
 
Reported: 2002-10-22 16:02 UTC by Unknown
Modified: 2010-01-05 21:03 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 Unknown 2002-10-22 16:02:49 UTC 
An attempt to import a CSV file as a spreadsheet gives wrong conversion 
results: if a new line character is a part of the value (e.i. withing the 
quotation marks "..." or '...') it is still interpreted as delimiter of a new 
record.
  For example, the value representing address "103 Borough Rd.//London//SE1 
0AA" is parsed as three different records (I used double slash (//) for new 
line character).
  This error occurs for every multiline element of MS Office which value is 
exported to CSV format.
Comment 1 prgmgr 2002-10-23 02:56:18 UTC 
Thank you for using and supporting OOo.

Please attach a short file that consistently reproduces this problem.
Comment 2 daniel.rentz 2002-10-23 09:02:45 UTC 
Known issue

*** This issue has been marked as a duplicate of 7370 ***
Comment 3 daniel.rentz 2002-10-23 09:03:40 UTC 
double->closed
Comment 4 sophikravitz 2010-01-05 21:03:13 UTC 
Version 3.1
When an Excel file is imported into Open Office calc, the sheet is renamed as
"Sheet 1". Therefore, any (external) software written to access something other
than "Sheet 1", say "Sheet 4", will not be accepted.
Unfortunately, Open Office does not allow the "Sheet 1" to be renamed and then
saved in csv format.

Interestingly, in version 3.0, the sheet is also named "Sheet 1" but is able to
be accessed.