Apache OpenOffice (AOO) Bugzilla – Issue 42694
tsv (tab seprated values) files cannot be opened in scalc
Last modified: 2010-06-30 12:00:13 UTC
A tsv file extension file can not be forced to open in scalc. This has been tried on OOO 1.1.2, 1.1.4 and also in the latest 1.9.x build of openoffice. I have created a flat file with the following data separated by tabs test test test test named the file test.tsv and when u associate the tsv file extension with scalc, it always openes up in writer. Comparative behaviour in Microsoft office is once I associate the file with excel, the file openes up in excel not in word. The problem was noticed in Windows 2000, Windows XP ( SP1), WIndows XP (SP2) and fedora core 3. If i rename the file extension to csv the file opens up in scalc as it should. The problem was noticed because Oracle Applications exports the files from its interface with a .tsv file extension, and openoffice was being evaluated for installation instead of Microsoft Office. This happens even if I open scalc and the use file --> open to open the test.tsv file, it opens up in writer. There seems to be no way to force scalc to open this file. Let me know if there are any additional details required.
Created attachment 22564 [details] test file with tab seprated values.
Hi, not a bug of OOo. tsv is not a known file extension to OOo even if you assign it to Calc. To open such file without renaming it to CSV just select the Filter to use. It's Test-CSV. This behaviour is correct as the file open dialog for OOo isn't Application dependend but Office wide, therefore a not known file with text content will open in Writer as this is the app. use dfor text. Frank
closed invalid
Hi, I can't help you with it, but maybe the StarOffice support from Sun has a solution. You nay try the following URL http://www.support-central.de/office , click on your country and search for 'Per Incident eMail Support'. Sorry for no better reply. Frank
Please cross-check with bug 69830, with Linux OOo calc 3.2 I just also ran into this issue: opening a .tsv file opened OOo writer, not another instance of calc. Not to recognise .tsv as tab separated values _is_ a bug IMHO. And if you think differently here, then allow opening it in calc by some other means that is not an import into an existing document.