First time here? Check out the FAQ!
asked 2012-05-03 16:08:14 +0200Geert Janssens
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 ?
answered 2012-08-17 22:05:20 +0200DonLow
I started to comment,but since I really believe this will work, I decided to post it as an answer. Since Calc opens your CSV file correctly, can you simply then save the Calc file in .ods format, and then open the ODS file in Base?
answered 2012-05-03 20:44:28 +0200mahfiaz
Is this what you are after? (see the last comment)
LibreOffice is made available by volunteers around the globe, backed by a charitable Foundation. Please support our efforts: Your donation helps us to deliver a better product!
Asked: 2012-05-03 16:08:14 +0200
Seen: 746 times
Last updated: Aug 17 '12