https://bugs.documentfoundation.org/show_bug.cgi?id=128513
--- Comment #27 from Silvain Dupertuis <silvain-dupert...@bluewin.ch> --- (In reply to Robert Großkopf from comment #25) > (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. This is what I tested : the example calc document has fields with line-breaks I created a fresh database connected at this calc document as it's database source and examined the table corresponding to the test sheet As the line-fields were lost in this database, I did not even try to copy the data into another database. -- You are receiving this mail because: You are the assignee for the bug.