I intended to have a spreadsheet which outputs data into a single copy-able cell, to be pasted into notepad or other text based applications.
In its simplest form, I intended something like this:
A1="Line1" A2="Line2" A3="Line3" A4=A1&CHAR(10)&A2&CHAR(10)&A3
Intended output (which shows correctly within Libreoffice):
Line1 Line2 Line3
Output when A4 is copied/pasted as text:
Is there a way around this?