I’m trying to import a csv file in libreoffice base. The peculiar thing about this csv file is that is contains fields with multi-line content.
I first opened the csv file in calc, which worked fine. Calc effectively displays the multi-line fields as multi-line.
Next I copied all cells and pasted them into an existing libreoffice base database table. While Calc handles the multi-line fields correctly, Base seems to discard any multi-line information. In base the field only holds one line, concatenating all the lines that make up the multi-line field. The field type in the table is TEXT/VARCHAR and is long enough to hold all the information.
Opening the table via a form also suggests the multi-line information has been stripped in the copy-past operation. I have created a form in which the field is displayed in a mult-line enabled text field, but all is shown as a single (long) line.
Any ideas how I can import multi-line content in a Base table ?