| Summary: | Cannot import non-csv file into Calc | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | PN <pascal.ggl> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED DUPLICATE | ||
| Severity: | normal | CC: | momonasmon, raal |
| Priority: | medium | ||
| Version: | 4.4.3.2 release | ||
| Hardware: | All | ||
| OS: | Linux (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
|
Description
PN
2016-04-01 09:41:39 UTC
Is this the same problem you reported previously in Bug 80016? Yes it is, and sorry for re-filing this. I forgot about the old one and it did not show up as hit when I submitted this new one... However, I still find this behaviour disfunctional, because: 1) it forces a certain behaviour upon the user which clearly is not intended (why would I open a word processor file in a spreadsheet application?). 2) the behaviour is inconsistent. If I rename the same file to .csv, it nevertheless opens in calc, ignoring the auto-file-type-detection. 3) opening a tab-delimited text file with a non-UTF8-encoding (because it was copied from another OS or just is old) is not such a rare thing really... In fact, I would argue that this happens more often than to open a very old Word Perfect file that does not end in .wpd. 4) Finally, LibreOffice is an unique application, at least on Linux, with no serious alternative. I find it problematic to impose such an "auto"-behaviour upon the user, essentially making it impossible from him to decide what is "right". In summary, it would really be great to be able to turn this auto-application-choosing off, either globally, or on a case by case basis. Let the user decide what is right... (In reply to PN from comment #2) > Yes it is, and sorry for re-filing this. I forgot about the old one and it > did not show up as hit when I submitted this new one... Thanks for confirming. So I'll close this one as a duplicate. > 1) it forces a certain behaviour upon the user which clearly is not > intended (why would I open a word processor file in a spreadsheet > application?). Yes you right. Actually the overall design of LO's file type detection framework is to open (if possible) in the same app. It's just the WordPerfect detection that is messing with this. And this doesn't happen with all files, only with files that have chars identical to WP's "codes". (And there were other cases of a similar mis-detection caused by the detection code of other formats.) Unfortunately it's not clear how to fix such thing, given that there is no way to "detect" csv files - as they are just plain text files, without any special header, so considering that a file is csv should be _always_ the last thing. > 2) the behaviour is inconsistent. If I rename the same file to .csv, it > nevertheless opens in calc, ignoring the auto-file-type-detection. It isn't ignoring anything. It just that ".csv" is a "known" extension, so checking this format takes higher priority than other formats - so WordPrefect has no change to "catch" it. > In summary, it would really be great to be able to turn this > auto-application-choosing off, either globally, or on a case by case basis. > Let the user decide what is right... Based on what said above, I can suggest a workaround: 1. Open Tools->Options... 2. Switch to LibreOffice->Advanced. 3. Click on "Expert Configuration". 4. In the search field type "generic_Text" in hit Enter. 5. Under org.openoffice.TypeDetection.Types['generic_Text'] there is a property "Extensions" listing all known extensions for plain text files - just add your extension there. 6. Restart LO. This does the trick for me with 5.1, but should work with your 4.4.3.2 too (but keep in mind that 4.4.x isn't supported by us anymore). Let me know if this won't work. *** This bug has been marked as a duplicate of bug 80016 *** |