Bug #75635 | MySQL for Excel Append function does not skip rows filtered in Excel | ||
---|---|---|---|
Submitted: | 26 Jan 2015 16:41 | Modified: | 28 Feb 2015 21:38 |
Reporter: | Ries Spruit | Email Updates: | |
Status: | Closed | Impact on me: | |
Category: | MySQL for Windows: MySQL for Excel | Severity: | S3 (Non-critical) |
Version: | 1.3.3 | OS: | Windows |
Assigned to: | CPU Architecture: | Any | |
Tags: | MySQL for Excel;Append;Filter |
[26 Jan 2015 16:41]
Ries Spruit
[11 Feb 2015 21:10]
Javier TreviƱo
Posted by developer: Fixed code used to temporarily store the selected Excel range used for an Export or Append Data operation so that it copies only visible rows (i.e. rows that have not been filtered out by an Excel Auto-Filter).
[28 Feb 2015 21:38]
Philip Olson
Posted by developer: Fixed as of the upcoming MySQL for Excel 1.3.4 release, and here's the changelog entry: When a named table in Excel was filtered using the standard Excel filtering option, this filter was not taken into account when the append function of the MySQL for Excel plugin was called. All rows of the table were inserted, not just the remaining (filtered) ones. Thank you for the bug report.