In Windows 10, I right-click on a ".txt" file, choose "Open with", then select "Choose another app", then pick "LibreOffice Calc". This brings up Writer and loads in the file, whereas I wanted to convert and read the file into a spreadsheet.
Steps to Reproduce:
1. right-click on a ".txt" file
2. choose "Open with"
3. select "Choose another app"
4. pick "LibreOffice Calc"
Writer is opened and loads in the file
Calc opens and provides options for which column separators to use
User Profile Reset: No
*** 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 188.8.131.52) 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 184.108.40.206.
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 220.127.116.11 on windows 10.