Issue 116209 - Bug with text separators when inporting csv files
Summary: Bug with text separators when inporting csv files
Status: CLOSED DUPLICATE of issue 113421
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 3.2.1
Hardware: PC Linux, all
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2010-12-22 21:34 UTC by sergiobobillier
Modified: 2011-01-03 12:52 UTC (History)
2 users (show)

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


Attachments
A shot of the issue described (66.33 KB, image/png)
2010-12-22 21:39 UTC, sergiobobillier
no flags Details
result oo3_4 (14.72 KB, image/gif)
2010-12-23 13:24 UTC, Oliver Brinzing
no flags Details
test csv file (146 bytes, text/plain)
2010-12-23 13:25 UTC, Oliver Brinzing
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description sergiobobillier 2010-12-22 21:34:07 UTC
How to reproduce this bug:

1. Create a CSV file with the semicolo (;) as separator and several fields, for
example this will do:

"Sergio"; 321269; "sergio@domain.net"; "Developer"
"Carlos"; 316582; "carlos@domain.net"; "Tester"
"Maria"; 216589; "maria@domain.net"; "Tester"

Note the space after the semicolo and before the next field, this is very important.

2. In OpenOffice select File -> Open, then browse to the CSV file and open it
3. In the import text dialog select "Separated" and use the semicolon (;) as
separator (make sure to uncheck the space if it is checked) and make sure the
double quotation mark (") is selected as the text separator.

What happens:

OpenOffice fails to correctly separate the fields, it doesn't recognize the text
separators and it keeps the " inside the cells.

What was expected:

I would expect OpenOffice to ignore the extra spaces after the semicolon
separators as Microsoft Excel does.
Comment 1 sergiobobillier 2010-12-22 21:39:20 UTC
Created attachment 75400 [details]
A shot of the issue described
Comment 2 Oliver Brinzing 2010-12-23 13:23:22 UTC
confirming - seems to be fixed in oo3.4m95 (oo3.3rc8 fails too)
please have a look at the attachments
Comment 3 Oliver Brinzing 2010-12-23 13:24:04 UTC
Created attachment 75402 [details]
result oo3_4
Comment 4 Oliver Brinzing 2010-12-23 13:24:23 UTC
.
Comment 5 Oliver Brinzing 2010-12-23 13:25:10 UTC
Created attachment 75403 [details]
test csv file
Comment 6 niklas.nebel 2011-01-03 12:51:41 UTC
Same as 113421.

*** This issue has been marked as a duplicate of 113421 ***
Comment 7 niklas.nebel 2011-01-03 12:52:04 UTC
closing duplicate