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 2016/05/07 07:17:51 UTC

[Issue 126956] New: CSV file not loaded/open correctly when one fields contains commas surrounded by double quotes

https://bz.apache.org/ooo/show_bug.cgi?id=126956

          Issue ID: 126956
        Issue Type: DEFECT
           Summary: CSV file not loaded/open correctly when one fields
                    contains commas surrounded by double quotes
           Product: Calc
           Version: 4.1.2
          Hardware: PC
                OS: Windows 10
            Status: UNCONFIRMED
          Severity: Major
          Priority: P5 (lowest)
         Component: open-import
          Assignee: issues@openoffice.apache.org
          Reporter: lsoucek@gmail.com

Created attachment 85528
  --> https://bz.apache.org/ooo/attachment.cgi?id=85528&action=edit
Example of file where some fields contains comma and are surrounded by double
quotes

I have CSV file (please see attachment) where some data fields contains comma
as part of text. Data in such fields are surrounded by double quotes (") as per
http://www.ietf.org/rfc/rfc4180.txt. This shall ensure they are taken as part
of single field content. Unfortunatelly Calc does not comply with specs and
breaks text. If I use different delimiter (like tab, semicolumn, etc.) than all
works fine. BTW Google sheets loads supplied file just fine.

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 126956] CSV file not loaded/open correctly when one fields contains commas surrounded by double quotes

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126956

--- Comment #3 from Libor <ls...@gmail.com> ---
Created attachment 85530
  --> https://bz.apache.org/ooo/attachment.cgi?id=85530&action=edit
Import Dialog setup during CSV file import

Example Text Import dialog when CSV is imported

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 126956] CSV file not loaded/open correctly when one fields contains commas surrounded by double quotes

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126956

Libor <ls...@gmail.com> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |RESOLVED
         Resolution|---                         |NOT_AN_ISSUE

--- Comment #5 from Libor <ls...@gmail.com> ---
I have set Text delimiter to double quotes ("). Import works as expected now.
Many thanks for help. Sorry for creating this bug and spending your time!

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 126956] CSV file not loaded/open correctly when one fields contains commas surrounded by double quotes

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126956

--- Comment #2 from Libor <ls...@gmail.com> ---
Environment and setup
1) I have just plain program installation on Win10 Pro.
2) CSV extension association is with AOO as done by installed program (no other
program installed on machine to manipulate with CSV, Open Doc/Calc formats,
etc.)).

Steps for CSV import (repro):
1) Supplied file is on file system.
2) I double click on file (via TotalCmd) and let association work.
3) When Text Import dialog appears I make sure setup is as shown on attached
file "TextImportDialog.png"
4) After OK click spreadsheet opens on screen
5) Row 1 with titles looks fine on spreadsheet but data are wrongly placed

Problem:
1) K2...S2 columns contain data which really belongs to K2 only
2) This problem is repeated on row 3 to 8 (essentially same text)

Text for K2 really shall contain text with commas included

This must be related to comma (,) delimiter selection (probably is used just
plain Split() function?) . When I have file with TAB delimiter than import is
OK (all required data are inserted into K cell as expected)

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 126956] CSV file not loaded/open correctly when one fields contains commas surrounded by double quotes

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126956

Marcus <ma...@apache.org> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|RESOLVED                    |CLOSED

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 126956] CSV file not loaded/open correctly when one fields contains commas surrounded by double quotes

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126956

--- Comment #4 from damjan@apache.org ---
Your "Text delimeter" is empty. Please set it to " and try again.

-- 
You are receiving this mail because:
You are the assignee for the issue.

[Issue 126956] CSV file not loaded/open correctly when one fields contains commas surrounded by double quotes

Posted by bu...@apache.org.
https://bz.apache.org/ooo/show_bug.cgi?id=126956

damjan@apache.org changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |damjan@apache.org

--- Comment #1 from damjan@apache.org ---
Works for me. Please describe the settings you use, and which cells contain
wrong text.

-- 
You are receiving this mail because:
You are the assignee for the issue.