[Libreoffice-bugs] [Bug 128513] no linefeeds when importing Calc tables that contain multiline text

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=128513

--- Comment #25 from Robert Großkopf <robert at familiegrosskopf.de> ---
(In reply to Silvain Dupertuis from comment #22)
> (In reply to Robert Großkopf from comment #19)
> > And a second very simple solution:
> > Set the Calc file as datasource of a new *.odb-file.
> > Copy the content from the Calc-database-file to your database.
> > Linebreaks will be imported to the internal database.
> 
> I tested this and it does not work.
> Line-breaks are lost if I create a fresh database and connect to the example
> calc file as datasource

This isn't what I described:
1. You need a Calc document with fields, which may have also linebreaks.
2. You need a first database, which only connects to Calc.
3. You need a second database, to which you will copy the content with the
linebreaks. The fields for the table must be datatype Memo (LONGVARCHAR in
HSQLDB, BLOB in Firebird). The linebreaks will be shown in the second database.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210817/0ca0cc6a/attachment.htm>