Issue 63478

Summary:	Import of csv data to calc
Product:	Calc	Reporter:	rabund <rbund>
Component:	open-import	Assignee:	spreadsheet <spreadsheet>
Status:	CLOSED DUPLICATE	QA Contact:	issues@sc <issues>
Severity:	Trivial
Priority:	P3	CC:	issues
Version:	OOo 2.0.2
Target Milestone:	---
Hardware:	PC
OS:	Windows 2000
Issue Type:	ENHANCEMENT	Latest Confirmation in:	---
Developer Difficulty:	---

Description rabund 2006-03-22 10:45:12 UTC

Hi,

I've got an file containing csv data which has the extension of .xls. When
opening this file by double clicking not calc but writer is started. 

Change this behaviour to opening calc. Such files are quite often generated by
programs as export files when the application is unable to write the correct
biff format.

regards,

Ralf

Comment 1 Joost Andrae 2006-03-23 10:42:45 UTC

A csv file is a simple text file. There's no way to determine if it's a text
file containing comma separated fields or if it's a different text file. If you
want such a behavior then rename those files with xls extension to have csv
extension. In this case the files will load into calc automatically. Resolving
as worksforme.

Comment 2 Joost Andrae 2006-03-23 10:43:01 UTC

closing

Comment 3 rabund 2006-03-23 12:25:32 UTC

Hi,

I know the difference between xls and csv. There are several programs on the
market, that export data to a .xls file. Actually the data are in a form of .csv
Data. When you're opening such a file using MS Excel the data are correctly read
into a spreadsheet. When you are opening this file using OO the file is openend
in Writer. Surely you can rename the file, but describe that to your standard
user in a company, you will get the answer, OO is stupid, MS Office does it the
right way.

I'm not reporting a bug, but a idea to make OO more useable.

regards,

Ralf

Comment 4 frank 2006-04-07 14:35:36 UTC

double to at least Issue 23078

*** This issue has been marked as a duplicate of 23078 ***

Comment 5 frank 2006-04-07 14:36:39 UTC

closed double

You may use the filter selection to pass such XLS files to the csv Filter.