To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=116209
Issue #|116209
Summary|Bug with text separators when inporting csv files
Component|Spreadsheet
Version|OOo 3.2.1
Platform|PC
URL|
OS/Version|Linux
Status|UNCONFIRMED
Status whiteboard|
Keywords|
Resolution|
Issue type|DEFECT
Priority|P3
Subcomponent|open-import
Assigned to|spreadsheet
Reported by|sergiobobillier
------- Additional comments from sergiobobill...@openoffice.org Wed Dec 22
21:34:07 +0000 2010 -------
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; "ser...@domain.net"; "Developer"
"Carlos"; 316582; "car...@domain.net"; "Tester"
"Maria"; 216589; "ma...@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.
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org
---------------------------------------------------------------------
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org
