Bug 93334 - [FILEOPEN] Problem importing CSV
Summary: [FILEOPEN] Problem importing CSV
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.0.5 release
Hardware: x86-64 (AMD64) All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: CSV-Import
  Show dependency treegraph
 
Reported: 2015-08-10 19:24 UTC by sdaniele78
Modified: 2019-12-06 01:33 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Sample data (26.71 KB, application/zip)
2015-08-10 19:24 UTC, sdaniele78
Details
Screenshot with the options that work for me. (61.19 KB, image/png)
2015-08-10 21:32 UTC, m.a.riosv
Details
Import process (242.12 KB, image/png)
2015-08-12 10:18 UTC, m.a.riosv
Details

Note You need to log in before you can comment on or make changes to this bug.
Description sdaniele78 2015-08-10 19:24:57 UTC
Created attachment 117814 [details]
Sample data

Importing the attached file freeze Calc.
Today I updated to last 5.0.0.5 because I got the same problem with earlier 4.4.x versions.
The same file works without the first row.
Comment 1 m.a.riosv 2015-08-10 21:32:35 UTC
Created attachment 117816 [details]
Screenshot with the options that work for me.

Hi @sdaniele78, thanks for reporting.

Works fine for me with both versions, may some option in the input window is the source of the issue.
Attached an screenshot with the options that work for me.
Comment 2 sdaniele78 2015-08-12 08:48:14 UTC
Ok, with your options it works for me too.
Try this:
- first select "Tab"
- then remove "Semicolon"

There is no "tab" on file so does not make sense to do that, but if you made a "wrong" click it freeze Calc.
Without the first row it works.



Daniele
Comment 3 m.a.riosv 2015-08-12 10:18:26 UTC
Created attachment 117856 [details]
Import process

In win seems freeze, after OK in the import window, but not, after a couple of minutes shows only one row of data, clicking again OK, shows the error message, clicking OK, import what fits in one cell.

For me not a bug, please if are not agree, reopen it.
Comment 4 sdaniele78 2015-08-12 13:09:14 UTC
I reopened the bug.

In Ubuntu 12.04, Calc freezed before I click "OK". After 5 minutes nothing happens, Calc is still freezed.
Anyway, what happens to you (m.a.riosv) is a bug too: there is a error message that it should not be and Calc take a couple of minutes to show that. 
Without the first row the file is imported in 1 second.
Comment 5 sdaniele78 2015-08-12 13:12:52 UTC
I also tryied to paste the first row of the file inside Calc cell and there wasn't problem, so no maximum number of characters was exceeded. Try you too please.
Comment 6 Buovjaga 2015-10-09 18:30:47 UTC
Well, it freezes with Tab selected.

Win 7 Pro 64-bit, Version: 5.0.2.2 (x64)
Build ID: 37b43f919e4de5eeaca9b9755ed688758a8251fe
Locale: fi-FI (fi_FI)
Comment 7 Buovjaga 2015-10-09 18:35:55 UTC
(In reply to Beluga from comment #6)
> Well, it freezes with Tab selected.
> 
> Win 7 Pro 64-bit, Version: 5.0.2.2 (x64)
> Build ID: 37b43f919e4de5eeaca9b9755ed688758a8251fe
> Locale: fi-FI (fi_FI)

Ah, it only froze for a minute.. same result as m.a.riosv.
Comment 8 QA Administrators 2016-11-08 11:12:56 UTC Comment hidden (obsolete)
Comment 9 QA Administrators 2019-12-03 14:44:26 UTC Comment hidden (obsolete)
Comment 10 m.a.riosv 2019-12-06 01:33:19 UTC
Works in the same way.
Version: 6.5.0.0.alpha0+ (x64)
Build ID: 60e8941fd581bb06cbf6be62edb8c387e7c07812
CPU threads: 4; OS: Windows 10.0 Build 19035; UI render: default; VCL: win; 
Locale: es-ES (es_ES); UI-Language: en-US
Calc: CL