Bug 494727

Summary: .xls opens in Calligra, despite system setting
Product: [Applications] systemsettings Reporter: Menno <mlabakker>
Component: kcm_filetypesAssignee: Plasma Bugs List <plasma-bugs-null>
Status: RESOLVED WORKSFORME    
Severity: normal CC: faure, nate
Priority: NOR    
Version First Reported In: 6.1.5   
Target Milestone: ---   
Platform: Kubuntu   
OS: Linux   
Latest Commit: Version Fixed/Implemented In:
Sentry Crash Report:
Attachments: System setting for .xls files
Requested extra screenshot

Description Menno 2024-10-14 10:05:16 UTC
Created attachment 174797 [details]
System setting for .xls files

SUMMARY


STEPS TO REPRODUCE
1. Type name of an .xls file on desktop, e.g. foo.xls
2. Click on "Recent files - foo.xls
3. Watch Calligra open the file instead of the specified LibreOffice Calc

OBSERVED RESULT
File opens in Calligra.

EXPECTED RESULT
File opens in LibreOffice, as configured in System Settings - Default Applications

SOFTWARE/OS VERSIONS

Linux/KDE Plasma: Kubuntu 24.10
KDE Plasma Version: 6.1.5
KDE Frameworks Version: 6.6.0
Qt Version: 6.6.2

ADDITIONAL INFORMATION
Comment 1 Nate Graham 2024-11-27 19:00:04 UTC
Can you also attach a screenshot that shows the ordering preferences for the "vnd.ms-excel" entry shown in your first screenshot?

Also, please run `file --mime-type <path to the Excel file, or drag it to the terminal window>` in a terminal window, and paste the output here.
Comment 2 David Faure 2024-11-27 20:57:10 UTC
You should ask for kmimetypefinder (QMimeType/shared-mime-info based) rather than `file --mimetype`, which uses its own database.
Comment 3 Menno 2024-11-29 11:20:24 UTC
Created attachment 176213 [details]
Requested extra screenshot
Comment 4 Menno 2024-11-29 11:27:28 UTC
(In reply to Nate Graham from comment #1)
> Can you also attach a screenshot that shows the ordering preferences for the
> "vnd.ms-excel" entry shown in your first screenshot?
> 
> Also, please run `file --mime-type <path to the Excel file, or drag it to
> the terminal window>` in a terminal window, and paste the output here.

Added screenshot.

$ file --mime-type testxlsx.xlsx 
testxlsx.xlsx: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet

$ file --mime-type testxls.xls 
testxls.xls: application/vnd.ms-excel

$ kmimetypefinder testxls.xls 
Detected locale "C" with character encoding "ANSI_X3.4-1968", which is not UTF-8.
Qt depends on a UTF-8 locale, and has switched to "C.UTF-8" instead.
If this causes problems, reconfigure your locale. See the locale(1) manual
for more information.
application/vnd.ms-excel

$ kmimetypefinder testxlsx.xlsx 
Detected locale "C" with character encoding "ANSI_X3.4-1968", which is not UTF-8.
Qt depends on a UTF-8 locale, and has switched to "C.UTF-8" instead.
If this causes problems, reconfigure your locale. See the locale(1) manual
for more information.
application/vnd.openxmlformats-officedocument.spreadsheetml.sheet


By the way: in the mean time I must have fixed something, behaviour is now as expected.
Comment 5 Nate Graham 2024-11-29 15:05:17 UTC
Thanks for the extra info, Menno and David. Everything looks sensible to me there. If you can't reproduce the issue anymore, then given the settings all look correct, unfortunately it's likely we won't be able to figure out what happened here.

If it happens again though, feel free to re-open this bug report and we can take another look. Thanks!
Comment 6 Menno 2024-11-29 15:10:40 UTC
(In reply to Nate Graham from comment #5)
> Thanks for the extra info, Menno and David. Everything looks sensible to me
> there. If you can't reproduce the issue anymore, then given the settings all
> look correct, unfortunately it's likely we won't be able to figure out what
> happened here.

I think what happened was the upgrade from Kubuntu 24.04 to 24.10, so maybe I had better filed it with Ubuntu developers.
Thanks for your replies.