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: | |
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
[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.