Bug 83069 - FILEOPEN: Comma Separated Value File Fails to open
Summary: FILEOPEN: Comma Separated Value File Fails to open
Status: RESOLVED WORKSFORME
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.3.0.4 release
Hardware: Other Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard: BSA
Keywords: possibleRegression
Depends on:
Blocks:
 
Reported: 2014-08-25 18:03 UTC by Richard A Blaine
Modified: 2015-12-15 10:57 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description Richard A Blaine 2014-08-25 18:03:55 UTC
Problem description: 
LO can create Text CSV (.csv) files correctly but has lost the ability to open such files; "Text CSV (.cvs)" is no longer is the list of file types which can be opened.

Clicking (Double clicking) on the file name on the windows desktop (Context menu) brings up LO Calc but attempts to import as a text file and is incorrect.

Drag and drop of a cvs file crashes LO and produces a following "recovery" loop

Steps to reproduce:
1. Click on a .csv file in a windows folder
or
2. Start Calc, click on OPEN, select the .csv file and attempt to change the file type to "Text CSV (.csv)" ... this file type does not appear in the file type list.
or
3.Open Calc and drag and drop a .csv file.  Crashes LO

Current behavior:
Unable to open .csv file as file type, "Text CSV (.csv) is not in the file-type list.

Expected behavior:
Drag and drop, double click on .csv file or OPEN with file type = "Text CSV (.csv) should open a csv file just as 4.5.2 and earlier versions did.

              
Operating System: Windows (other)
Version: 4.3.0.4 release
Last worked in: 4.2.6.2 release
Comment 1 tommy27 2014-08-26 07:52:13 UTC
(In reply to comment #0)
> 
>....
> 2. Start Calc, click on OPEN, select the .csv file and attempt to change the
> file type to "Text CSV (.csv)" ... this file type does not appear in the
> file type list.
>...

I'm using LibO 4.3.0.4 under Win7x64 and I see "Text CSV (.csv)" in the dropdown extension menu list of the open dialog.

maybe you just missed it since the list is very long.
try clicking "t" in that menu list till you see it.

> 3.Open Calc and drag and drop a .csv file.  Crashes LO

no crash on drag and drop
Comment 2 Richard A Blaine 2014-08-26 15:30:56 UTC
Thanks, tommy27.

  I am running Vista Home x64 and definitely do NOT find "Text CSV 
(.csv)" in the dropdown extension menu list of the open dialog.

However, I discovered the reason why I was unable to open the .csv file 
sucessfully; when I installed LO 4.3.0.4 last week the default Character 
set changed to Unicode (UTF-16) from Unicode (UTF-8) in previous 
versions.  Changing to the latter allowed me to open .csv files 
successfully.  I do not have a clue as to what UTF-7,8 or 16 means.  
"System" seems to work also

Dick Blaine
Cupertino, CA

On 8/26/2014 12:52 AM, bugzilla-daemon@freedesktop.org wrote:
> tommy27 <mailto:barta@quipo.it> changed bug 83069 
> <https://bugs.freedesktop.org/show_bug.cgi?id=83069>
> What 	Removed 	Added
> CC 		barta@quipo.it
>
> *Comment # 1 <https://bugs.freedesktop.org/show_bug.cgi?id=83069#c1> 
> on bug 83069 <https://bugs.freedesktop.org/show_bug.cgi?id=83069> from 
> tommy27 <mailto:barta@quipo.it> *
> (In reply tocomment #0  <show_bug.cgi?id=83069#c0>)
> >
> >....
> > 2. Start Calc, click on OPEN, select the .csv file and attempt to change the
> > file type to "Text CSV (.csv)" ... this file type does not appear in the
> > file type list.
> >...
>
> I'm using LibO 4.3.0.4 under Win7x64 and I see "Text CSV (.csv)" in the
> dropdown extension menu list of the open dialog.
>
> maybe you just missed it since the list is very long.
> try clicking "t" in that menu list till you see it.
>
> > 3.Open Calc and drag and drop a .csv file.  Crashes LO
>
> no crash on drag and drop
> ------------------------------------------------------------------------
> You are receiving this mail because:
>
>   * You reported the bug.
>
Comment 3 Florian Reisinger 2014-09-04 13:49:05 UTC
Tested with Windows 7 with Version: 4.4.0.0.alpha0+ Build ID: 5ef4bdc7b15686e55fa19f2e98a828763a0cfae6 TinderBox: Win-x86@42, Branch:master, Time: 2014-09-03_10:10:14. Failed reproducing the bug
Comment 4 Robinson Tryon (qubit) 2015-12-15 10:57:49 UTC
Migrating Whiteboard tags to Keywords: (possibleRegression)
[NinjaEdit]