You are viewing a plain text version of this content. The canonical link for it is here.
Posted to issues@openoffice.apache.org by bu...@apache.org on 2014/02/26 11:19:24 UTC
[Bug 124318] New: Import of cvs files does not break at line endings
https://issues.apache.org/ooo/show_bug.cgi?id=124318
Bug ID: 124318
Issue Type: DEFECT
Summary: Import of cvs files does not break at line endings
Product: Calc
Version: 4.0.1
Hardware: PC
OS: Linux
Status: UNCONFIRMED
Severity: major
Priority: P3
Component: open-import
Assignee: issues@openoffice.apache.org
Reporter: hhue13@gmail.com
CC: issues@openoffice.apache.org
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).
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124318] Import of csv files does not break at line endings
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124318
Edwin Sharp <el...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords| |needmoreinfo
Summary|Import of cvs files does |Import of csv files does
|not break at line endings |not break at line endings
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124318] Import of csv files does not break at line endings
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124318
--- Comment #9 from Edwin Sharp <el...@apache.org> ---
Maybe try newer snapshot:
http://ci.apache.org/projects/openoffice/#linux64
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124318] Import of cvs files does not break at line endings
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124318
Edwin Sharp <el...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |elish@apache.org
--- Comment #4 from Edwin Sharp <el...@apache.org> ---
Created attachment 82713
--> https://issues.apache.org/ooo/attachment.cgi?id=82713&action=edit
screenshot of text import dialog
With these settings import seems ok.
Please advise.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124318] Import of cvs files does not break at line endings
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124318
--- Comment #2 from hhue13@gmail.com ---
Created attachment 82710
--> https://issues.apache.org/ooo/attachment.cgi?id=82710&action=edit
csv file to be imported
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124318] Import of csv files does not break at line endings
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124318
--- Comment #8 from hhue13@gmail.com ---
Comment on attachment 82717
--> https://issues.apache.org/ooo/attachment.cgi?id=82717
spreadsheet
Exactly how I'd like the import to look like. Too bad it does not work for me
like this.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124318] Import of csv files does not break at line endings
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124318
--- Comment #7 from Edwin Sharp <el...@apache.org> ---
Created attachment 82717
--> https://issues.apache.org/ooo/attachment.cgi?id=82717&action=edit
spreadsheet
This is how my import looks like
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124318] Import of csv files does not break at line endings
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124318
--- Comment #5 from Edwin Sharp <el...@apache.org> ---
AOO410m1(Build:9750) - Rev. 1571426
2014-02-25_04:10:58 - Rev. 1571555
Debian
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124318] Import of csv files does not break at line endings
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124318
--- Comment #10 from hhue13@gmail.com ---
(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.
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124318] Import of csv files does not break at line endings
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124318
Edwin Sharp <el...@apache.org> changed:
What |Removed |Added
----------------------------------------------------------------------------
Keywords|needmoreinfo |needhelp
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124318] Import of cvs files does not break at line endings
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124318
Andre <aw...@googlemail.com> changed:
What |Removed |Added
----------------------------------------------------------------------------
CC| |awf.aoo@googlemail.com
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124318] Import of cvs files does not break at line endings
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124318
--- Comment #3 from hhue13@gmail.com ---
Created attachment 82711
--> https://issues.apache.org/ooo/attachment.cgi?id=82711&action=edit
Resulting .ods file from the csv import
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124318] Import of csv files does not break at line endings
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124318
--- Comment #6 from hhue13@gmail.com ---
Comment on attachment 82713
--> https://issues.apache.org/ooo/attachment.cgi?id=82713
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).
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.
[Bug 124318] Import of cvs files does not break at line endings
Posted by bu...@apache.org.
https://issues.apache.org/ooo/show_bug.cgi?id=124318
--- Comment #1 from hhue13@gmail.com ---
Created attachment 82709
--> https://issues.apache.org/ooo/attachment.cgi?id=82709&action=edit
Details of Linux & OO Environment
--
You are receiving this mail because:
You are on the CC list for the bug.
You are the assignee for the bug.
You are watching all bug changes.