| Bug #72971 | No table relations detected in Office 2007 and 2010 | ||
|---|---|---|---|
| Submitted: | 12 Jun 2014 1:55 | Modified: | 30 Jun 2014 23:11 |
| Reporter: | Javier Treviño | Email Updates: | |
| Status: | Closed | Impact on me: | |
| Category: | MySQL for Windows: MySQL for Excel | Severity: | S3 (Non-critical) |
| Version: | 1.3.0 | OS: | Any |
| Assigned to: | CPU Architecture: | Any | |
[12 Jun 2014 1:57]
Javier Treviño
Posted by developer: Fixed some conditions in the code that was preventing relationships for selected tables and views (multi-selection) to be processed, so related tables and views were not found and listed.
[30 Jun 2014 23:11]
Philip Olson
Fixed as of the upcoming MySQL for Excel 1.3.1 release, and here's the changelog entry: When importing tables, the "Pick related Tables or Views" feature did not function in Excel 2007 or Excel 2010, but did in Excel 2013. Thank you for the bug report.
Description: Related tables and views are not being detected on Excel 2007 and 2010 (Excel 2013 works fine). How to repeat: 1. Enable MySQL for Excel Plugin in MS Excel "Data" tab. 2. Import tables which share a relation to a third table ("sakila.actor" and "sakila.film"). 3. The "Import Data" dialog will appear but the "Pick related Tables or Views" list will be empty. Actual Results: In Office 2013 the table "film_actor" is shown in the "Pick related Tables or Views" list.