Retaining line breaks when pasting multi-row text form Calc

[Algu6]

Hello! In Excel this worked by itself, but I am having this problem ever since moving to LibreOffice.
For example, I have following information set in Calc

  Column  A

Row 1

               Hello!

              My name

               is...

Row 2

             I live...

               in...

Row 3

              My age
           
               is...

Now when I copy a single cell and paste it into a notepad linebreaks are preserved.
eg.

               Hello!

              My name

               is...

When I copy multiple rows at once and paste them… Linebreaks from inside cells are gone
eg.

            Hello! My name is...

             I live... in...

How do I keep the linebreaks when pasting?

[yusufbolu]

Did you try Edit > Paste Special > Paste Special > Rich Text Formatting (RTF)?

[Lupp]

Hmmm, a kind of workaround:
You can prepare a range in your spreadsheet using the formula =SUBSTITUTE(A1;CHAR(10);CHAR(13)) and respective. Copying this range and pasting it into the plain text editor should do as you want.

(Calc cells use U+000A for internal line breaks.)
And: Line breaks in spreadsheet cells should be avoided. For decades they were not accepted at all.

[Algu6]

A good solution was to create another cell with this function:

=CONCATENATE(A1,CHAR(10),CHAR(10),A2,CHAR(10),CHAR(10),A3)

This way the new cell contains collective information from all of the cells and retains the line breaks

To anyone who is struggling with the same issue!

[Lupp]

Clever Idea! However, if your version of LibO is 5.4 or higher:

Eveb better use =TEXTJOIN(CHAR(10);1;A1:A3).
It’s simpler to enter / edit and clearer to the eye.