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

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