Import from Calc to Base without losing line breaks

[Mouse345]

I have a Calc spreadsheet that I want to move into a Base table. Many of the cells are multiline, with line breaks.
When I try to import it into Base, I always lose the line breaks.
I’ve made sure the columns are in memo format, and can type in the line breaks manually in the Base table. But they don’t show up when I paste from Calc.

Can anyone find some way to do that, or even a workaround that a relative novice to Base can use?

I’ve seen two similar questions, but unfortunately, neither had a real answer to what I’m looking for.

Preserving line breaks when importing from Calc into Base

I am trying to import data from Calc into Base, and have done some preparation on the Calc sheet: The top row contains the column names, the remaining rows are data. Some of my data has line breaks, which I would like to preserve. I have followed the standard procedure of selecting the entire sheet, copying it to the clipboard, then pasting it into the Tables window in Base. I have selected LONGVARCHAR as the data type for the fields which have line breaks. However, when I look at the data, it…

How can I import multiline text from a Calc table into a Base table without loosing line-breaks ?

I have imported a whole set of Access Database tables into LO Base quite easily, in just 2 steps: 1) copy-paste tables or query into Calc, then 2) copy-past from Calc into Base. The only problem is with Memo multiline fields in step 2: because line breaks are lost when transferring data from Calc into a Base table. Is there a way to preserve these line breaks? (Note: I am using LO 5 on Ubuntu. I just used a Virtual Windows XP to open my Access database to transfer data to Calc, but this is irr…

[Ratslinger]

Hello,

Open item here → tdf#128513