Apache OpenOffice (AOO) Bugzilla – Issue 63478
Import of csv data to calc
Last modified: 2006-04-07 14:36:39 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
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.
closing
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
double to at least Issue 23078 *** This issue has been marked as a duplicate of 23078 ***
closed double You may use the filter selection to pass such XLS files to the csv Filter.