Apache OpenOffice (AOO) Bugzilla – Issue 124318
Import of csv files does not break at line endings
Last modified: 2020-01-03 00:03:27 UTC
The problem here is that importing a csv im OOO calc on Linux obviously does not honor line endings properly as multiple lines of the csv file are concatenated together into one line in calc. Hence the resulting file is not usable at all. I've tried to convert the .csv using unix2dos before importing but the problem did not change. This bug seems to be very similar to 82952 however this problem still exists and the 82952 is very old therefore I'm opening a new bug here. Due to this problem it is not possible to import CSV files on Linux into calc what is a major impact to the usability of the application. A fix would be needed as having to use excel as an intermediary it not really an option. Attaching the following documents: OOSystemInfo.odt -> Information about Linux installation & OpenOffice details wp_vmstatlog_2014.02.25.csv.gz --> source csv file for import wp_vmstatlog_2014.02.25.ods.gz --> resulting ods file (see OOSystemInfo.odt for the import options).
Created attachment 82709 [details] Details of Linux & OO Environment
Created attachment 82710 [details] csv file to be imported
Created attachment 82711 [details] Resulting .ods file from the csv import
Created attachment 82713 [details] screenshot of text import dialog With these settings import seems ok. Please advise.
AOO410m1(Build:9750) - Rev. 1571426 2014-02-25_04:10:58 - Rev. 1571555 Debian
Comment on attachment 82713 [details] screenshot of text import dialog Thanks for your response here. Tried the same settings but I still get the same (wrong) result. Not sure if the OS makes a difference (I'm on RHEL).
Created attachment 82717 [details] spreadsheet This is how my import looks like
Comment on attachment 82717 [details] spreadsheet Exactly how I'd like the import to look like. Too bad it does not work for me like this.
Maybe try newer snapshot: http://ci.apache.org/projects/openoffice/#linux64
(In reply to Edwin Sharp from comment #9) > Maybe try newer snapshot: > http://ci.apache.org/projects/openoffice/#linux64 Tried the current 4.1.0 version from the download link provided but still the same problem. Whereby here again it's the same as in the 4.0.1 version namely that in the preview the import lools OK but when the csv is finally importet I again get the incorrect result.
I cannot reproduce this. Please test again with a recent version and attach a screenshot of your text import settings dialog.
No news from OP