Bug #84291 Error refreshing MySQL data when the add-in's sidebar is not visible

• Submitted: 21 Dec 2016 2:21
• Modified: 30 May 2017 18:03
• Reporter: Javier Treviño
• Status: Closed
• Category: MySQL for Windows: MySQL for Excel
• Severity: S3 (Non-critical)
• Version: 1.3.6
• OS: Any
• CPU Architecture: Any

[21 Dec 2016 2:21] Javier Treviño

Description:
An error occurs trying to refresh imported MySQL data when the MySQL for Excel sidebar is not visible.
The error thrown reads something like:

An error ocurred trying to refresh MySQL data in the Excel table "xxx.yyy".
Object reference not set to an instance of an object.

There is also a typo in the error message in "ocurred" which should read "occurred".

How to repeat:
1. Open Excel
2. Click on the MySQL for Excel button in the Data ribbon to show the sidebar.
3. From the side panel, double-click a connection, select a schema and any table
4. Click on Import MySQL Data
5. Make sure in the Advanced Options the option to create an Excel table for the imported data is checked
6. Import the data
7. Click on the MySQL for Excel button in the Data ribbon to hide the sidebar.
8. Right-click on any Excel cell within the imported region, select "Refresh"
9. Note the error message is thrown.
10. Click on the MySQL for Excel button in the Data ribbon to show the sidebar.
11. Right-click on any Excel cell within the imported region, select "Refresh"
12. Note no error appears.

[21 Dec 2016 2:50] Javier Treviño

Posted by developer:
 
Fixed the refreshing code to avoid attempting to update properties in the sidebar if it is not visible.

[5 May 2017 15:14] Rafael Antonio Bedoy Torres

Posted by developer:
 
Still failing on 1.3.7 build 2

[5 May 2017 23:28] Javier Treviño

Posted by developer:
 
Moved code that was clearing connection information when hiding the sidebar to the point when the add-in is shutdown instead.

[19 May 2017 19:32] Rafael Antonio Bedoy Torres

Posted by developer:
 
Fixed on 1.3.7 build 3

[19 May 2017 21:29] Christine Cole

Posted by developer:
 
Attempting to refresh MySQL data in an Excel worksheet while the MySQL for Excel task pane was closed generated an error.