Export as xls error

[yonderboi]

When I export a query as xls, the expansion of the resulting file is xlsx, but the real file format is xls. So when I try to open the file, an error message appears
11.0.6.1776

 

[Marco Kalter]

Can you let me know the exact steps to reproduce this?

 

[yonderboi]

Sure
1. select 1 from dual
2. Press "Export query results...", select "Excel file"
3. When selecting file type stay with "XLS-files", enter file name blahblahblah, then save.
4. The resulting file is blahblah.xlsx, not xls
5. Click to open it, you'll see "Excel cannot open the file "blahblah.xlsx" because the file format for the file extension is not valid. Verify that the file has not been corrupted and that the file extension matches the format of the file"

 

[Marco Kalter]

Can you go to Tools > Preferences > Files / Format and let me know the "Excel export format" setting?

 

[yonderboi]

"Ask" is set

 

[Marco Kalter]

When selecting "Excel file" from the export menu, how is the setting of the "Save as type" selector of the file selector?

 

[yonderboi]

"XLS Files(*.xls)"