Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing |
Summary: | Opening .tsv files in calc | ||
---|---|---|---|
Product: | Calc | Reporter: | ottodv <otto2003> |
Component: | open-import | Assignee: | AOO issues mailing list <issues> |
Status: | CONFIRMED --- | QA Contact: | |
Severity: | Trivial | ||
Priority: | P3 | CC: | dynvec, issues, leonfrench, mwgreaves |
Version: | OOo 2.0.2 | ||
Target Milestone: | --- | ||
Hardware: | All | ||
OS: | All | ||
Issue Type: | ENHANCEMENT | Latest Confirmation in: | --- |
Developer Difficulty: | --- |
Description
ottodv
2006-09-25 11:13:46 UTC
Hi, if you open the file via File-Open, select the Text-CSV Filter and it should work as you've found out. If you use Insert-Sheet from File, select the file and click Ok The importer should have Tab selected as delimiter. This is not possible for File-Open as this dialog has to deal with all kinds of documents. So I think this is a double to Issue 42694 and therefore should be closed. But let's requirements decide. Frank Issue 42694 was for a defect, which it isn't because this feature is not implemented currently. The current issue is a request for an enhancement, in other words I request that this feature be added to OOo. I also request that this issue not be closed unless a) it can be shown that this feature would violate some standard and it would be wrong to open .tsv in calc instead of writer or b) the feature is implemented. I can confirm from following forum threads and enquiries in the users' list that requests for a straightforward way to open such files arise frequently. The present procedure is especially problematic for users who are required to open many such files. It may seem like a small matter to those of us who are not in that position but, particularly in a commercial environment, the present procedure can be an unacceptable time waster. It requires that the user have the choice of associating the file with the application to be used and OpenOffice honouring that association. "if you open the file via File-Open, select the Text-CSV Filter and it should work as you've found out." In reference to this comment, in OO 2.03, this workaround does not work. No file with extension .tsv will show up when you try that workaround, and thus no .tsv file can be opened in this manner. Hi, so you have to first select the file and than set the filter type, not that complicated I think. Frank Well actually it seems to be non-intuitive, if one selects Text CSV for file types shown in the open file dialog .tsv files will not show. You'd expect a list all the file types which could potentialy be of the Text CSV type. Hence the confusion. But at least with the work around explained by Frank, tab is automatically selected as the default delimiter, so there is some kind of support for .tsv files (also if I rename the same file to .csv it selects comma by default, so it's not based on file content but file name). If we could just have .tsv files open directly in calc instead of writer it would be perfect... I don't think this should be considered an issue of opening just .tsv files and associating them with a specific OOo application. There should be a way of opening a file in an OOo application of my choosing, whether I want to open an .xls file in Writer or a .zip in Calc. I am pretty satisfied with the default behaviour, OOo does a good job guessing what I want most of the time. Very good indeed. But users should be able to tell the software they want to open a file in a specific application, regardless of the file type. Why should the software stop me from doing this? Software should only stop me from doing dangerous things, like wiping the hard drive, which clearly is not the case. I heartily agree with Additional comments from cfzlp Tue Oct 3 03:37:14 -0700 2006 . My own posts show that I believe computers and programs should be SERVANTS of the user, not disciplinarian or master, in stark contrast to views of Bill Gates. Design smart defaults, but let knowledgeable user override them, because NO programmer can anticipate every intent or need. (That's why computers have not yet replaced all people.) I observe the same problem when opening a tab-delimited file that has the ".xls" suffix -- it opens up as a text document, never even asking me for the format. I get the "ascii filter option" modal dialog, after which the file is opened as a Writer document. This is IMHO wrong. Sorry for being new to the forum and already voicing an opinion, but last night I was struggling with this issue and thinking there should be a "Force Open" option in addition to the standard "Open" button. This option would force which ever module opened the "File Open" dialogue to open the file (or at least make an attempt, it may then fail if the user has selection something that just totally doesn't make sense). From the (very limited) reading I have done, I think this will address most of the concerns that have been voiced. This problem is a show stopper that prevents me and my coworkers from even using Open Office. We have many tab delimited report files that we need to open in Calc simply by double clicking on the file through the Windows file manager. I need to associate the ".tab" file type in the Windows file manager to open the file in Calc. Instead, the file opens in Writer. No disrespect to the OO developers, but this shouldn't be considered an enhancement, but rather a bug. If it's not opening the application that I explicitly request, that's a bug. In fact, Calc should be intelligent enough to identify which delimiter is being used without even prompting the user (at least for common delimiters such as commas (.csv) and tabs (.tab and .tsv)). Only in cases where the delimiter can't be identified, then the user should be prompted. Another concern is how consistently the OO developers downplay the importance of this issue. There are so many threads of users dealing with this same issue, it should just be fixed. Please don't sentence us to a future with MicroSoft! I would like to add a comment for OO developers. If a feature 'just works right' in MS Office, then you better make sure the exact same feature 'just works right' for a new user trying to switch from MS Office to Open Office. Another way of putting this was expressed by Joel, of Joel on Software: "Something is usable if it behaves exactly as expected." http://www.joelonsoftware.com/design/1stDraft/03.html Now, it is a fact that most Open Office end users are already familiar with an MS Office user interface. So, when they try out Open Office, they will first try to perform a given task using their knowledge from MS Office. When Open Office diverges from the well known MS Office user interface, users will be frustrated because Open Office didn't behave as expected. The .tsv problem is a good example. The feature 'just works right' in MS Office, and it does not 'just work right' in Open Office...yet. In OOo version 2.0.4 on Linux, am I now able (in Nautilus) to associate files with the extension .tsv and actually have them open in calc! It even selects the tab delimiter by default. OOo apparently no longer redirects the open request to the writer. That's great but... However if I try to open a .tsv file from calc, it opens it in writer after all! If I select "spreadsheets", .tsv files do not show either. The work around with file type still works however. A step in the right direction, but the problem is not entirely resolved. fst mentioned: "so you have to first select the file and than set the filter type, not that complicated I think." It is more complicated than most of my users are able to do. You must first open calc, select the file and then pull the rigt filter from a drop sown list of over 60 items. You must alse remeber the order of the steps ( Ok: two steps ) but if you set the filter first and try to select the file second it will not work. It is completely counterintuitive. I donĀ“t know which anoys me most. Either the fact that I asociate the TSV extension with CALC and OpenOffice will disregard my orders, or that the EASIEST work around is to open it in Microsoft Excel. The problem I reported is no longer occurring for me. I recently did a clean install of Fedora 9, which includes OpenOffice.org 2.4.1. Double clicking on a .tsv file now automatically opens it in calc with the proper dialog. Can it be confirmed that this issue has been resolved? THIS HAD BEEN FIXED BEFORE! As of version 2.3 this had been fixed. My company has a system thet generates Tab-separated files but names them .txt. I could right click on the link, tell it to open in calc, and I would get the import dialog. To me this was a fix from older verions that opened it in Writer even if I asked for Calc. The problem REAPEARED in the beta for 3.0 ( build 9328 ) I use this a lot. I will probably not upgrade my users. The TSV file format definition is very simple: http://www.iana.org/assignments/media-types/text/tab-separated-values TSV has a particular advantage over CSV, which is simplicity. In my projects I often find users who were supposed to manipulate data exported from other systems are often confused with multiple options provided by CSV, e.g. text delimiter, field delimiter. gnumeric recognizes .tsv format and opens without asking user a single question like the text delimiter (because there is none, tab-separated-values do not distinguish text and digits) or field delimiter. This gives advantage for system implementors like me to provide user with TSV format with the confidence user will ask less questions to support team or mess up data by answered wrongly about text delimiter. I think OOO should do alike. Furthermore although TSV format did not specify what is the EOL, I recommend always default to CRLF (despite OS difference) for two reasons: 1) more application accepts CRLF than CR or LF; 2) it provide the convenience that non-Windows users can process the TSV file with text tools like AWK, using CRLF as record separator would let them accept table cells that contain linebreak in either CR or LF. It's not necessary to add TSV available in "Sheet from File" function because those who use that function is probably aware of the delimiter concepts. *** Issue 95959 has been marked as a duplicate of this issue. *** Hello, this problem still (or again) manifests in 3.2 . I love tab-separated files and have just renamed it from the default .csv . I consider the information on the separator essential since one could otherwise run into some ambiguity when attempting to open various files. Please rank this on up, it is more of an issue than you apparently think. Another disappointed Open Office user attempting to convince a developer (pretty sure one person could do this) to spend all of an hour on a very much needed fix: if file has .tsv extension then open in calc with filter set to delimiter=tab That's all. Can we, the beneficiaries of your hard work and time, please see this simple logic implemented? Latest Confirmation in: 4.1.3 Creating this post I realized I had an old version so re-created the test I made with 4.1.2 yielding the same results. I started by opening a TSV with Windows explorer contextual menu Open with > OpenOffice Calc. As I saw no activity, I tried opening the file and it do so as a text file. I then did the same but selecting the filter for Spreadsheets which would hide the TSV. I then found this issue and a post in it suggested selecting the file before using the filter and did so but again it opened as a text file. Finally as I was closing the files to update AOO I was the flat-file DB import window. So in addition to adding my support to this issue, I'd like to suggest that the import window be assigned to a new file, instead of an old one; ie: you have the following files showing in the calc group "A, B, C" and when in B you try importing that a new file be created, ie D, and that the import window be associated with D instead of B, as otherwise the window will only show when selecting B. |