Bug #72975 Import don't retrieve data at left columns from a previous import
Submitted: 12 Jun 2014 3:05 Modified: 30 Jun 2014 23:57
Reporter: Javier Treviño 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

[12 Jun 2014 3:05] Javier Treviño
Description:
Data can't be imported to the left of a previously imported data if the new data intersects with the existing import.

How to repeat:
1. Enable the MySQL for excel plugin.
2. Open a valid connection.
3. Click on the J2 cell.
4. Import sakila.actor.
5. Click on the A3 cell.
6. Import sakila.actor.
7. Note the data won't be imported.
[19 Jun 2014 22:48] Javier Treviño
Posted by developer:
 
Enhanced the code that refreshes an Excel table to smartly resize it before binding it according to the new size of its data source. If the new size is bigger than before, new columns or rows will be inserted to make room for the new Excel table size. Added code to show errors to the user upon Excel tables or PivotTables creation.
[19 Jun 2014 22:54] Javier Treviño
Posted by developer:
 
The fix done works-around a bug (or limitation) in Excel VSTO, since the fix needs to be done even when there is enough room for a ListObject in the Excel worksheet.  More information about that limitation in the links below:

http://social.msdn.microsoft.com/Forums/vstudio/en-US/a8dd0bbd-7e2a-4ba3-8f8a-dd4c22c8e5f6...
https://connect.microsoft.com/VisualStudio/feedback/details/573867/vsto-excel-listobject-s...
[30 Jun 2014 23:57] Philip Olson
Fixed as of the upcoming MySQL for Excel 1.3.1 release, and here's the changelog entry:

Data could not be imported to the left of previously imported data if the
new data intersected with the existing import.

Thank you for the bug report.