Hello,
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:
Line1Line2Line3
Is there a way around this?