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
• Status: Closed
• Category: MySQL for Windows: MySQL for Excel
• Severity: S3 (Non-critical)
• Version: 1.3.3
• OS: Windows (Office 2007 Professional)
• 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!