Issue 63478 - Import of csv data to calc
Summary: Import of csv data to calc
Status: CLOSED DUPLICATE of issue 23078
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 2.0.2
Hardware: PC Windows 2000
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Depends on:
Reported: 2006-03-22 10:45 UTC by rabund
Modified: 2006-04-07 14:36 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description rabund 2006-03-22 10:45:12 UTC

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.


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
Comment 3 rabund 2006-03-23 12:25:32 UTC

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.


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.