Summary: | Attempting to open a ".txt" file with Calc selected from Windows explorer "Open with", opens Writer instead | ||
---|---|---|---|
Product: | LibreOffice | Reporter: | taw |
Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
Status: | NEW --- | ||
Severity: | enhancement | CC: | aron.budea, fitojb, himajin100000, ilmari.lauhakangas, vermelhusco1904 |
Priority: | medium | Keywords: | notBibisectable, regression |
Version: | 6.0.6.2 release | ||
Hardware: | All | ||
OS: | Windows (All) | ||
Whiteboard: | |||
Crash report or crash signature: | Regression By: |
Description
taw
2018-10-22 15:00:29 UTC
*** Bug 120944 has been marked as a duplicate of this bug. *** I am finding this hard to bibisect, because pointing to the scalc.exe makes it open just fine in Calc. Same for --calc command line parameter. I tried to do it after User Profile reset and it still happened. I'll just confirm that I tried this in Linux (Ubuntu 18.04) and did not see the problem - it opened up in Calc. So it probably is Windows only. I think this is not a Calc bug. When I try on my system (Win 7, 64bit 6.0.1.1) I am only offered Libre Office (not calc). I suspect the bug lies in the LO UI or installation and the filetype registrations it makes. Indeed, if you simply open a spreadsheet you will find that soffice is the container application: scalc is no longer visible outside it in Windows. Use File Open, and click on the All Files *.* dropdown, and you will see that .txt files are defined as writer documents. A workaround is simply to rename the file as a .csv .csv files are regarded as spreadsheet text files: some attempt will be made to parse them. There are workarounds. Not obvious workarounds. It would be good if this behaviour is corrected anyway because forcing users to waste time looking for workarounds is frustrating and they'll just go for the simplest workaround: open the file in Excel. We have the same issue. On windows 7 and 10 using LO 6.1.5.2. When opening a .BOM files which contain text for one it loads it in Calc and another in Writer. No matter if we specify 'scalc.exe' or 'soffice.exe --calc'. LO seems to try to detect the file type and overrides our choice. When opening the file from within Calc it is also opened with Writer. When we first select the file in the Open Dialog and then select 'Text CSV (*.csv)' as type then it opens the file in Calc (opens the Text Import wizard). Can confirm that bug is still present with 6.2.5.2 on windows 10. Can confirm, reproduced on version: 7.0.3.1 (x64 windows 10) Changing to notBibisectable because of no known way to use Win explorer integration with bibisect repos Can confirm, reproduced on version: 7.3.5.2 (Ubuntu 22.04.1 LTS) It could open certain .php files with Calc sometimes But doesn't work for something. The two files have the exact same headers. The biggest difference is the size. Not sure if size matters, just guessing. (the one works is 123.5kb and the one doesn't work is 1.1MB) Once I change the 1.1MB file's extension to .xls it works just fine. This would be good to fix, because plenty of times instead of wanting to open .csv files I want to manipulate .txt files that have the data organized in columns separated by tabs. These type of .txt files can be generated by a multitude of software including RStudio, which is where I generate .txt files with tabular separators to import to Calc. Would be nice that there is no assumption about what .txt files are for and to force open them on Writer instead. |