Bug #75389 Excel save file formats gone after MySQL-for-Excel started. Only .xls available
Submitted: 1 Jan 2015 21:57 Modified: 1 Mar 2015 5:27
Reporter: le quattro Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL for Windows: MySQL for Excel Severity:S3 (Non-critical)
Version:1.3.3 OS:Microsoft Windows (Office 2007 Professional)
Assigned to: CPU Architecture:Any
Tags: Excel save file formats disappear, only .xls available

[1 Jan 2015 21:57] le quattro
Description:
If I start the "MySQL for Excel" and the window appears on the right side, nearly all available save file format options in Excel (.xlsm, .csv and all others) disappear. Only .xls-Format is still available. It´s not possible to save the file with macros and scripts anymore as they are deleted.

See https://www.youtube.com/watch?v=N_nryaZddXw

Windows 2008 Server, Office 2007 Professional. All Patches. MySQL for Excel 1.3.3.

How to repeat:
See small (unlisted) youtube video here:

https://www.youtube.com/watch?v=N_nryaZddXw

Same problem with new blank empty excel file.
[2 Jan 2015 11:25] MySQL Verification Team
Thank you for the bug report.
[13 Feb 2015 2:02] Javier Treviño
Posted by developer:
 
Verified this only happens in Excel 2007 because of the override of the Save As dialog MySQL for Excel does due to the lack of a WorkbookAfterSave event in Excel 2007.
[13 Feb 2015 6:32] Javier Treviño
Posted by developer:
 
Changed the method to display a custom Save As dialog when a Workbook is saved in Excel 2007 to one that supports showing all Excel supported file filters.
[28 Feb 2015 21:56] Philip Olson
Posted by developer:
 
Fixed as of the upcoming MySQL for Excel 1.3.4 release, and here's the changelog entry:

For Excel 2007, only ".xls" files were available in the "Save As" dialog.
Now, all formats supported by Excel 2007 are available.

Thank you for the bug report.
[1 Mar 2015 5:27] le quattro
Thank you very much for fixing this issue!