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:
None 
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
Description:
When a named table in Excel is filtered using the standard Excel filtering option, this filter is not taken into account when the append function of the MySQL for Excel plugin is called. All rows of the table are inserted, not just the remaining ones. 

The plugin would be a more useful tool if skipping filtered rows would be supported via an option. 

At this point it is unusable for filtered tables as too much data will be inserted on calling the append function. 

Also, at this moment the only way to detect that the filtered rows are also inserted, is to check the operation log. There is no immediate indication as to whether filtered rows are inserted or not.

How to repeat:
Filter a named table in Excel and use the plugin to Append the data to a table in MySQL. 

Check the number of rows reported in the operations log and in the table. This will show filtered rows are also inserted. 

Suggested fix:
Bugfix:
On calling Append funciton, give a warning that rows not visible due to filtering are actually also appended to the table in MySQL

Feature request:
Create a checkbox to configure whether or not to also append rows that are currently invisible due to filtering of source table (in Excel).
[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.