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.