Bug 120796 - Attempting to open a ".txt" file with Calc selected from Windows explorer "Open with", opens Writer instead
Summary: Attempting to open a ".txt" file with Calc selected from Windows explorer "Op...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.6.2 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords: bibisectRequest, regression
: 120944 (view as bug list)
Depends on:
Blocks:
 
Reported: 2018-10-22 15:00 UTC by taw
Modified: 2019-01-23 09:43 UTC (History)
4 users (show)

See Also:
Crash report or crash signature:


Attachments

Note You need to log in before you can comment on or make changes to this bug.
Description taw 2018-10-22 15:00:29 UTC
Description:
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"

Actual Results:
Writer is opened and loads in the file

Expected Results:
Calc opens and provides options for which column separators to use


Reproducible: Always


User Profile Reset: No



Additional Info:
Comment 1 Buovjaga 2018-10-26 19:09:57 UTC
*** Bug 120944 has been marked as a duplicate of this bug. ***
Comment 2 Buovjaga 2018-10-26 19:11:34 UTC
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.
Comment 3 Pedro 2018-10-30 18:30:25 UTC
I tried to do it after User Profile reset and it still happened.
Comment 4 Justin L 2019-01-16 12:42:20 UTC
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.
Comment 5 Libomark 2019-01-23 00:54:51 UTC
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.
Comment 6 Libomark 2019-01-23 01:17:34 UTC
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.
Comment 7 Pedro 2019-01-23 09:43:46 UTC
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.