Apache OpenOffice (AOO) Bugzilla – Issue 116209
Bug with text separators when inporting csv files
Last modified: 2011-01-03 12:52:04 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.
Created attachment 75400 [details] A shot of the issue described
confirming - seems to be fixed in oo3.4m95 (oo3.3rc8 fails too) please have a look at the attachments
Created attachment 75402 [details] result oo3_4
.
Created attachment 75403 [details] test csv file
Same as 113421. *** This issue has been marked as a duplicate of 113421 ***
closing duplicate