In some older bug reports (bug 38133, bug 40233, bug 61557, bug 68903, bug 87836) files with extension 'tsv' (tab-separated values, see: http://en.wikipedia.org/wiki/Tab-separated_values) are mentioned. It seemed to me that there is a special treatment in LibreOffice similar to csv files. If this is the case, files with these extensions should be treated completely equal to csv files. This is currently not the case (1) in the file filters of the file open dialogue, files with the extension tsv are not mentioned there; (2) during saving, it is not possible to save a file the extension tsv. Hint: This Bug has already been described in Bug 89312 together with other problems.
Hello, for me it looks like .tsv is subset of .csv Could you attach testing .tsv file?
(In reply to raal from comment #1) > Hello, > for me it looks like .tsv is subset of .csv > > Could you attach testing .tsv file? See parent bug 89312
Created attachment 113921 [details] Small .tsv test file.
Yes a couple of additional delimited text formats need to be added to the "Spreadsheets" group filter. The group filter list contains .csv and .xls, but should include addition of: *.tsv *.tab *.csv.gz =-ref-= http://opengrok.libreoffice.org/xref/core/sfx2/source/dialog/filtergrouping.cxx
Importing of the TSV file format seems to work fine. (I don't know anything about the other format types mentioned in this bug report). I don't see any value in exporting anything other than the most common CSV format. The CSV could be converted into the other text formats by a dedicated converter tool I'm sure. So in my opinion, this bug report can be closed.
(In reply to Justin L from comment #5) > Importing of the TSV file format seems to work fine. (I don't know anything > about the other format types mentioned in this bug report). > > I don't see any value in exporting anything other than the most common CSV > format. The CSV could be converted into the other text formats by a > dedicated converter tool I'm sure. So in my opinion, this bug report can be > closed. Think issue remains that, on Windows for example, there is no LibreOffice "association" of the .tsv in the 'Spreadsheet' "globalfilter" class. The .csv is there and responds to os/DE opening, but .tsv|.tab|.csv.gz etc. are not. Also, since LibreOffice doesn't record itself as a program handling these other delimeted formats--so user must use os/DE to select "open file with", and find the launcher for the desired LO module. And if call is made from an open Writer session, it will open into Writer (bug 89683 so => WFM). So, IIRC what is still missing are the "localfilter" classes for opening these formats into specific LO modules. E.g. to list the available filters in os/DE and pick specific filter from the list.