Bug 130413 - File Save: Calc uses wrong file extension when copying the name from a file with a different extension
Summary: File Save: Calc uses wrong file extension when copying the name from a file w...
Status: RESOLVED DUPLICATE of bug 111070
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.4.0.3 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2020-02-04 07:11 UTC by Jonas Müller
Modified: 2020-05-10 12:21 UTC (History)
1 user (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 Jonas Müller 2020-02-04 07:11:03 UTC
Description:
LibreOffice Calc uses the wrong file extension in this case:

1. Make sure there is an .ods file on your desktop like "target.ods". The content doesn't matter. It can be an empty file.
2. Open a file like source.csv form your download directory. The content doesn't matter
3. Open the file
4. Click file - save as and choose Excel 97-2003 .xls as file type.
5. Enter the character * into the file name and press enter to make the Windows save as dialogue display all files in this folder.
6. Click on the file "target.ods" to fill the field "file name" with the value "target.ods"
7. Now change the field "file name" to "target 2" (without extension)
8. Confirm that you want to save the file as an excel file.

Expected result:

LibreOffice should append the proper file extension ".xls" so the file will have the name "target 2.xls"

Actual result:

The file is named "target 2.ods" but it is actually an .xls file.
Modern Microsoft Office applications like Excel 2019 will refuse to open this file because to the wrong file extension.

This bug happened with LibreOffice Calc but other programs may be affected as well. This may be an Windows only bug.

Steps to Reproduce:
1. Make sure there is an .ods file on your desktop like "target.ods". The content doesn't matter. It can be an empty file.
2. Open a file like source.csv form your download directory. The content doesn't matter.
3. Open the file
4. Click file - save as and choose Excel 97-2003 .xls as file type.
5. Enter the character * into the file name and press enter to make the Windows save as dialogue display all files in this folder.
6. Click on the file "target.ods" to fill the field "file name" with the value "target.ods"
7. Now change the field "file name" to "target 2" (without extension)
8. Confirm that you want to save the file as an excel file.

Actual Results:
The file is named "target 2.ods" but it is actually an .xls file.
Modern Microsoft Office applications like Excel 2019 will refuse to open this file because to the wrong file extension.

Expected Results:
LibreOffice should append the proper file extension ".xls" so the file will have the name "target 2.xls"


Reproducible: Always


User Profile Reset: No


OpenGL enabled: Yes

Additional Info:
Comment 1 Jonas Müller 2020-02-04 07:20:28 UTC
Edit: Forgot to mention: Between step 4 and 5 you have to navigate to your desktop in the save as dialogue of course.
Comment 2 Buovjaga 2020-05-10 12:21:30 UTC
I found an older report which seems to cover this.

*** This bug has been marked as a duplicate of bug 111070 ***