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.