MySQL Bugs: #72964: Fix Refresh problem when users change Excel table names of imported MySQL data

Bug #72964	Fix Refresh problem when users change Excel table names of imported MySQL data
Submitted:	11 Jun 2014 23:36	Modified:	30 Jun 2014 20:48
Reporter:	Javier Rivera Zavala	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL for Windows: MySQL for Excel	Severity:	S3 (Non-critical)
Version:	1.3.0	OS:	Any
Assigned to:		CPU Architecture:	Any

Description:
When refreshing data for Excel tables created from imported MySQL data the Excel table name is used to do the binding with a MySqlDataTable object.
If the users change the Excel table name in Excel the binding can't be done anymore thus the data is not refreshed.
The code needs to be changed to circumvent this problem.

How to repeat:
1. Open Excel, click Data Tab in the ribbon and click MySQL for Excel Icon to open the plugin.
2. Double click a connection and schema.
3. Select any table (click over it) and click the import button on the current panel.
4. Click import button on the current dialog, change some cells values to verify the refresh doesn't take place at step 6/7.
5. On the Design tab at the excel ribbon, click over the Table name textbox and change the table name.
6. At the excel worksheet right click the table and select Refresh.
7. Notice the warning that pops up and how the table is not refreshed

Suggested fix:
do not depend on Excel's Table name to perform the data refresh.

Posted by developer:
 
The beta version of excel (1.3.0) was making use of the excel table name to refresh the connection from the database. This fix makes the refresh possible without relying on the name of the table, Import Sessions created before 1.3.1 will be affected and will no longer work with this fix.

Posted by developer:
 
Fixed, checked using mysql-for-excel-commercial-1.3.1.

Fixed as of the upcoming MySQL for Excel 1.3.1 release, and here's the changelog entry:

Imported data would not refresh if the table name was changed in
Excel during the import. The table name is no longer used to verify the
MySQL connection.

Thank you for the bug report.