Bug 40680 - FILEOPEN LibreOffice Calc is importing content of csv file wrong, when line feeds in text
Summary: FILEOPEN LibreOffice Calc is importing content of csv file wrong, when line f...
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.5.0 Beta1
Hardware: x86-64 (AMD64) Windows (All)
: high critical
Assignee: Kohei Yoshida
QA Contact:
Whiteboard: target:3.5
Depends on:
Reported: 2011-09-07 03:53 CEST by christof.spies
Modified: 2013-05-01 00:22 CEST (History)
0 users

See Also:
Crash report or crash signature:

csv with linefeeds in text area. (9.69 KB, text/csv)
2011-09-07 03:53 CEST, christof.spies
Test-case for described problem (65 bytes, text/csv)
2011-11-11 00:47 CET, a10860967

Note You need to log in before you can comment on or make changes to this bug.
Description christof.spies 2011-09-07 03:53:37 CEST
Created attachment 50954 [details]
csv with linefeeds in text area.

LibreOffice 3.4.3 
OOO340m1 (Build:302)
Windows 7 64bit

1. Open the attached file with Libre office.
2. Use the following import settings:
 * Encoding: UTF-8
 * Language: German
 * Starting line: 1
 * Delimiter options: Tabulator only
 * Text delimiter: "
 * Extended Number detection: true
3. OK

(Not sure if this the the correct translation, but you will find the fields in the import dialog.)

In row 4 and column Q the import is not ok.
Openend with a text editor this cell should be:
"xx xxxxx xxx xxxxxxxxx xxxxxxxx xxxxxxxxx xxxxxxx xxx xxx xxxxxxx:
- xxxxxxxx xxxxxxx xxxxxx (xxxxxxx, xxxxxxx, xxxxxxxx, xxxxxx, xxxxxxx, xxxxxx)
- xxxxxxxxx xxx xxxx xxxxxx, xxxxxxx xxx xxxxxx xxxxxxx
- xxxxxx xxxxxxxxx xxxxxxxxx: xxxxxxxxxx xxxxxxxxxx xxxxxxxxxxxxx, xxxxxxxx xxx xxxxxxxxxxxx
- xx xxxx, xxxx xxx xxxxx xxx xxxxx xxx xxxxxx xxxxxxxxxx"
But it's only "xx xxxxx xxx xxxxxxxxx xxxxxxxx xxxxxxxxx xxxxxxx xxx xxx xxxxxxx:"
The rest of the cell is going per line in a new row in colomn A. And damages the data on saving.
Comment 1 Josef.Latt 2011-09-10 00:13:10 CEST

(In OOo 3.3 its o.k.)
Comment 2 a10860967 2011-11-11 00:47:54 CET
Created attachment 53391 [details]
Test-case for described problem

Test case for newlines within text delimiter.
Works for values1.1 and value1.2 (first column) 
but not for value2.1 and value2.2
Comment 3 a10860967 2011-11-11 00:49:10 CET
The wrapping of newlines with text delimiters works for the first column, but not for columns after the first.
Comment 4 Björn Michaelsen 2011-12-23 12:41:42 CET
[This is an automated message.]
This bug was filed before the changes to Bugzilla on 2011-10-16. Thus it
started right out as NEW without ever being explicitly confirmed. The bug is
changed to state NEEDINFO for this reason. To move this bug from NEEDINFO back
to NEW please check if the bug still persists with the 3.5.0 beta1 or beta2 prereleases.
Details on how to test the 3.5.0 beta1 can be found at:

more detail on this bulk operation: http://nabble.documentfoundation.org/RFC-Operation-Spamzilla-tp3607474p3607474.html
Comment 5 christof.spies 2011-12-23 16:27:26 CET
Bug is still there:
LOdev 3.5.0 
Build-ID: 7362ca8-b5a8e65-af86909-d471f98-61464c4
Comment 6 Kohei Yoshida 2012-01-07 10:10:09 CET
Yes, I fixed this one just recently though I didn't realize there was a bug report for it.

Please test 3.5 Beta3.  It should be fixed there.
Comment 7 wingfire 2013-05-01 00:22:28 CEST
working with Version (Build ID: 4c82dcdd6efcd48b1d8bba66bfe1989deee49c3)