These newlines most likely come from your gnucash data itself. Are these
imported transactions or are the descriptions copied/pasted from somewhere
outside of gnucash ?
It's a known problem gnucash is not always properly sanitizing external data.
It will happily insert newlines in a transaction description if you paste some
text with a newline or when you import transactions in which the description
does have newlines.
You can try and remove this newline in gnucash using the delete key on the
transaction descriptions for the ones that are causing trouble.
However let me also add for completeness I believe Excel is misinterpreting
the csv file or you need to tweak your import settings in that application.
The transaction description is quoted and the newline is inside the quotes, so
in principle Excel should treat the newline as part of the description and not
as the start of a new line.
Libreoffice is doing this correctly. Perhaps you need to tell Excel the import
data is quoted or something similar ? I can't tell the exact options to use as
I don't have MsOffice software on my system.
Re: [GNC] Corrupted transaction export file - is this a bug, or do I do something wrong
Still using an outdated version of GNU Cash which is fine apart from export
file as above. Typing in the file name and type (csv) and then clicking next
produces a file which opens in Excel, only problem in the figures have odd
characters in the same cell.
If this is something that's sorted in later version will upgrade,
alternatively is there a workaround- perhaps using the report function?