https://bugs.documentfoundation.org/show_bug.cgi?id=93376
Bug ID: 93376
Summary: Importing CSV Files Fails
Product: LibreOffice
Version: 5.0.0.5 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: major
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 117848
--> https://bugs.documentfoundation.org/attachment.cgi?id=117848&action=edit
Test showing the broken import functionality
When importing a csv file (FILEOPEN) (specifically a "Bulk Export" from
FreePBX), it gets all screwed up when it encounters a field with quotation
marks.
I don't believe this problem happened in 4.xx because I used it all the time
and didn't encounter this issue.
I've tried unchecking all the various options in the import, and tried changing
the character set, always the same result.
"The data could not be loaded completely because the maximum number of
characters per cell was exceeded."
The field that triggers this looks like this:
,"Caller Name" <7145555555>,
What happens is the cell looks like this:
Caller Name" <7145555555>,all,the,rest,of,the,data
including,the,next,rows,everything
shows,up,in,this,cell,until,it,encounters,another
cell,like that
This is a HUGE problem for me, this is the #1 purpose I use Calc for, and I
cannot use this until it's fixed.
Attached example.
All import options are off except: [x]Comma, Text Delimiter is " (double
quote).
It's not closing the delimiter when it hits the 2nd double quote.
Files:
test1 - Shows how the bug works as I've described.
test2 - Can only attach 1 file, test2 is pasted below:
------------------test2--------------------------------
Name,Phone,CallerID,Miscellaneous
test,555555555,5555555555,bla blah blah,"context,menu,priority"
test2,543422332,1241232134,still ok...,"help,test,2"
Rob,7145555555,"rob test" <7145555555>,this is where it breaks,"cat,goes,4"
test3,444412323,444124213,uh oh still broken,"hello,test,5"
test4,99999999,99999999,what can i do?,"broken,extension,1"
test5,44444444,44444444,here is a text,"context,menu2,1"
-------------------end of data----------------------------
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
