Issue 120151 - csv files to not open correctly
Summary: csv files to not open correctly
Status: CLOSED IRREPRODUCIBLE
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: 3.4.0
Hardware: All All
: P3 Normal (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords: needmoreinfo
Depends on:
Blocks:
 
Reported: 2012-07-02 15:38 UTC by elw112358
Modified: 2017-05-20 09:58 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
screen shots of spreadsheet as opened by OO and Excel (909.64 KB, image/jpeg)
2012-07-02 15:38 UTC, elw112358 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description elw112358 2012-07-02 15:38:29 UTC 
Created attachment 78551 [details]
screen shots of spreadsheet as opened by OO and Excel

When I open a downloaded .csv file in version OO 3.3 or OO 3.4, some data is merged in the 1st column and the rest scatterd into the wrong columns.  A 3 column spreadsheet had data in 43 columns.  If I manually correct the display and save the file, it no longer displays properly in Excel. I observe that similar reports say this is fixed or invalid (bug 113981). As you can see from the attached screen images, the problem still exists.  I know the images say Libre Office.  This is because I tried that after having the problem in Open Office 3.3 and 3.4.  I have had to go back to version 3.2 to get files to open properly.
Comment 1 Terry Yang 2012-08-31 07:55:34 UTC 
Can you please upload your sample file, from the screenshot, the CSV contain lots of semicolon.
Comment 2 Rob Weir 2013-03-21 20:05:03 UTC 
I attempted to reproduce the defect you reported but was unsuccessful. 

We really need the CSV file, but a screen shot to make any progress with this.

I'm marking this issue as RESOLVED/IRREPRODUCIBLE. If we receive more information on how to reproduce the issue, we can reopen.

Then close issue as RESOLVED/IRREPRODUCIBLE