Bug 116894 - unable to load CSV file
Summary: unable to load CSV file
Status: RESOLVED INVALID
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.3.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: perf, regression
Depends on:
Blocks:
 
Reported: 2018-04-09 01:41 UTC by perie_gut
Modified: 2018-04-10 14:47 UTC (History)
3 users (show)

See Also:
Crash report or crash signature:

Attachments
csv test file (deleted)
2018-04-09 01:41 UTC, perie_gut 		Details
Show Obsolete (1) View All Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description perie_gut 2018-04-09 01:41:34 UTC 
Created attachment 141222 [details]
csv test file

unable to load csv
Comment 1 raal 2018-04-09 12:39:08 UTC 
I can confirm with Version: 6.1.0.0.alpha0+
Build ID: 4f268695787ff6c7052269058f7ae6de34abfd5d
CPU threads: 4; OS: Windows 6.1; UI render: default; 

You set this bug as regression - which is last know working version?
Comment 2 V Stuart Foote 2018-04-09 17:23:27 UTC 
Bad data. At line/record 13146 there is an entry "Not Applicable" in the employer_c field, records 1 - 13145 load with no issue. 

Clean the data to remove the quote marks--or change the import dialogs "String delimiter" listbox selection from " to '.

Import then works correctly.

Also we need to remove this attachment 141222 [details] -- clear privacy issues in the contained data. 

Xisco, would you please!
Comment 3 Xisco Faulí 2018-04-10 14:47:21 UTC 
The content of attachment 141222 [details] has been deleted for the following reason:

private data