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.