Created attachment 145888 [details] csv file demonstrating the buggy import of Row 3, beginning with "J4" Open the attached .csv file in a text editor. You'll see that row 3 contains "J4" right up front. If you import it into Calc using only commas as delimiters, however, for some reason it does NOT put this "J4" on row 3 onto a new row. Instead, it appends it to the very end of the preceding row. It seems to be some sort of parsing issue that makes LibreOffice ignore new-line characters in certain instances. Definitely a bug.
Created attachment 145889 [details] Text import screen showing the newline char (displayed as an arrow pointing to the left) bug only happens when I have a "String delimiter" of " chosen. Text import screen showing the newline char (displayed as an arrow pointing to the left) bug only happens when I have a "String delimiter" of " chosen.
i can confirm this, but IMHO you have to replace all double-quotes with pairs of double quotes from: ,""5.5 2.1 plug male 10"" to: ,"""5.5 2.1 plug male 10""" https://stackoverflow.com/questions/43273976/escaping-quotes-and-delimiters-in-csv-files-with-excel/43274459
Hello Oliver, Thanks for the tip. Closing as RESOLVED NOTABUG