Created attachment 101056 [details]
An ods spreadhseet, with a \n in one cell.
Steps to reproduce:
1. Load attached sample file. It has a paragraph as one cell
2. export to CSV
Does not give option to replace '\n' in content with something else. As a result, it produces an invalid CSV; ie one line is split into two.
This may be a feature request: ie, one way to read this bug is that it ought to give an option (but not necessarily enforce) translation of '\n' to another character.
Created attachment 101062 [details]
Export plus import options
Hi Chris, thanks for reporting.
Works for me with:
Version: 18.104.22.168 Id. Build: 882f8a0a489bc99a9e60c7905a60226254cb6ff0
When saving you can select to edit filter settings.
And when opening you can set up import options.
Look at mine in the attached image file.
(In reply to comment #1)
My complaint is about the export. If I'm importing it back into LibreOffice, it figures out the \n inside " " should not mean a newline.
But for other csv readers, it is very confusing for a row to be split with a newline. It would be very nice if there was an option to replace certain characters (the separator character, maybe, but certainly newlines) during the export.
Created attachment 101065 [details]
Search and replace for new lines
It's possible to do it before export with Find&Replace.
And as you want a new option, please change the importance from normal to enhancement.
Setting as new enhancement. Warn user as excel do this. Maybe add option to csv filter settings, but you can change \n with search&replace. But user need to know that problem, so warning is needed.
Created attachment 110188 [details]