Bug #83987 MySQL for Excel appears to hang after pressing Export Excel Data to New Table

Submitted: 28 Nov 2016 14:03 Modified: 30 Nov 2016 13:17
Reporter: James Schrage Email Updates:
Status: Not a Bug Impact on me:
None 
Category:MySQL for Windows: MySQL for Excel Severity:S1 (Critical)
Version:latest OS:Windows (Windows 10)
Assigned to: CPU Architecture:Any

[28 Nov 2016 14:03] James Schrage
Description:
MySQL for Excel addon for Microsoft Excel 2016 appears to hang after selecting a connection and then a schema database and then pressing the Export Excel Data to New Table link.  No response occurs, the MySQL for Excel seems dead.

How to repeat:
MySQL for Excel addon for Microsoft Excel 2016 appears to hang after selecting a connection and then a schema database and then pressing the Export Excel Data to New Table link.  No response occurs, the MySQL for Excel seems dead.

Suggested fix:
No fix known at this time - appears to be a bug.
[29 Nov 2016 17:58] James Schrage
Ok I found what was causing the hang.  I noticed that the spreadsheet workbook was in both compatibility mode and shared mode.  I removed both compatibility mode and shared mode and the export excel to MySQL worked.  Thank you!
[30 Nov 2016 13:17] Chiranjeevi Battula
Hello James Schrage,

Thank you for the bug report.
I'm glad that you found a solution for your problem and let us know if you are still having the issue with complete repeatable steps.

Thanks,
Chiranjeevi.

Portions of this website are copyright © 2001, 2002 The PHP Group

Page generated in 0.049 sec. using MySQL 8.4.7-u6-cloud

Timestamp references displayed by the system are UTC.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.