Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Import csv with multi-line fields into LO base

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 ?

click to hide/show revision 2
retagged

Import csv with multi-line fields into LO base

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 ?

click to hide/show revision 3
retagged

Import csv with multi-line fields into LO base

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 ?

Import csv with multi-line fields into LO base

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 ?