Issue 116919 - Calc import CSV ignores text delimiter
Summary: Calc import CSV ignores text delimiter
Status: CLOSED DUPLICATE of issue 113421
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOO320m19
Hardware: Unknown Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-02-11 00:15 UTC by schufty
Modified: 2011-02-11 09:16 UTC (History)
1 user (show)

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


Attachments
Import CSV screen (60.04 KB, image/png)
2011-02-11 00:15 UTC, schufty
no flags Details
Imported CSV with text delimiter ignored (61.06 KB, image/png)
2011-02-11 00:16 UTC, schufty
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description schufty 2011-02-11 00:15:02 UTC
My CSV file looks like this...

Number, Color, Letter, Sequence, Direction
One, Red, , , Up
Two, Blue, , , Down
Three, Green, Alpha, "A, B, C", West

On import, column delimiter is set to "Comma" and the "Text delimiter" field is 
set to double quotes.  Note the fourth column in the third row: it's a quoted 
comma-delimited list.  Calc is importing each element in the list as a separate 
column rather than importing them all together as a single text value.  In 
addition, it's placing the first double-quote in the same cell as "A" and the 
second double-quote in the cell with "C".  Calc should import the text "A, B, C" 
as a single cell without double-quotes.  It's clearly ignoring the text 
delimiter.

I'll attach screenshots of the import dialog and the resulting CSV in case the 
above description isn't clear.
Comment 1 schufty 2011-02-11 00:15:43 UTC
Created attachment 75813 [details]
Import CSV screen
Comment 2 schufty 2011-02-11 00:16:39 UTC
Created attachment 75814 [details]
Imported CSV with text delimiter ignored
Comment 3 niklas.nebel 2011-02-11 09:16:00 UTC
The problem is the space after the comma, see issue 113421.

*** This issue has been marked as a duplicate of 113421 ***
Comment 4 niklas.nebel 2011-02-11 09:16:22 UTC
closing duplicate