Bug 95718 - Importing CSV files
Summary: Importing CSV files
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.3.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2015-11-10 07:55 UTC by Jan Ågren
Modified: 2015-11-13 07:48 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments
Sample of .csv file (66.35 KB, application/vnd.ms-excel)
2015-11-10 17:33 UTC, Jan Ågren
Details
printscreen (129.54 KB, application/octet-string)
2015-11-10 19:20 UTC, raal
Details

Note You need to log in before you can comment on or make changes to this bug.
Description Jan Ågren 2015-11-10 07:55:34 UTC
When importing a .csv file. Fieldseparator is set semicolon and comma.
The field view window shows fieldseparation is OK, but importing the file all lines are loaded in cell A1 to Axxx until end of file.

I will get a overflow warning of maximum number of signs in a cell.


This is a new issue, previous version imported the same files ok.
I am not able to give you an examplefile just now.

Sincerely
Jan Ågren
Comment 1 raal 2015-11-10 12:21:50 UTC
Hello Jan,

Thank you for filing the bug. Please send us a sample document, as this makes it easier for us to verify the bug. 
I have set the bug's status to 'NEEDINFO', so please do change it back to 'UNCONFIRMED' once you have attached a document.
(Please note that the attachment will be public, remove any sensitive information before attaching it.)
How can I eliminate confidential data from a sample document?
https://wiki.documentfoundation.org/QA/FAQ#How_can_I_eliminate_confidential_data_from_a_sample_document.3F
Thank you

I can not confirm with LO 5.0.2.2, win7 with my test csv file
Comment 2 Jan Ågren 2015-11-10 17:33:16 UTC
Created attachment 120457 [details]
Sample of .csv file

This file can be opened in version 5.0.2.2 without any problem.
On version 5.0.3.2 the import will read the labels and then assemble all data lines into one cell.

Hope you will find the fault.


Regards
Jan Ågren
Comment 3 raal 2015-11-10 19:20:27 UTC
Created attachment 120461 [details]
printscreen

I can not confirm with LO 5.0.3.2, win7
Comment 4 Buovjaga 2015-11-12 12:23:40 UTC
Cannot reproduce.

Seems weird, so suggesting this: https://wiki.documentfoundation.org/UserProfile#Resolving_corruption_in_the_user_profile

Win 7 Pro 64-bit, Version: 5.0.3.2 (x64)
Build ID: e5f16313668ac592c1bfb310f4390624e3dbfb75
Locale: fi-FI (fi_FI)

Version: 5.1.0.0.alpha1+
Build ID: b216cc1b8096eb60c27f67e8c27b7cd756c75e38
TinderBox: Win-x86@62-merge-TDF, Branch:MASTER, Time: 2015-11-12_00:06:20
Locale: fi-FI (fi_FI)

Set to NEEDINFO.
Change back to UNCONFIRMED, if the problem persists. Change to RESOLVED WORKSFORME, if the problem went away.
Comment 5 Jan Ågren 2015-11-13 07:16:23 UTC
Restored the configuration and now it's ok.

Thanks a  lot

/Jan Agren
Comment 6 Buovjaga 2015-11-13 07:48:37 UTC
Thanks, setting to WFM.