Please describe the problem:
When viewing a filtered subset of data using autofilter, making a multi row
selections expands to a contiguous selection of the unfiltered data.

This causes problems, if you want to export some data via the clipboard from a
subset based on autofilter. Worst case is that you could accidentally transmit
data that is not desired to be released.

Steps to reproduce:
1. Enter some data on muliple rows
2. Add an autofilter to the sheet
3. Using autofilter, show a sparse subset (Eg rows B,D,F,H)
4. Select/copy the data
5. Paste into another sheet, or into an external app.



Actual results:
*  Data from C,E,G is also copied.

Expected results:
Data from the filtered rows only should be copied/pasted, and condensed to a
dense rectangular selection.

Does this happen every time?
Yes

Other information:
I suspect this going to be fairly difficult to implement, and the work around is
to add a column with your selection criteria in an =IF(...,"SELECT","") formula,
then sort by that, and then make your selection/copy whatever. This requires to
be able to edit the file though which is inconvenient if it is read only.