Create a spreadsheet like the following...
C1   C2
A    1
B    2
C    3
D    1
E    2
F    3
G    6
H    2
I    2
J    5

Put the cursor in cell A1 (value 'C1') and turn on auto-filter.
In the B1 (value 'C2') dropdown, select "2".
Even though only the rows "B", "E", "H", and "I" are visible, clicking B and
dragging the selection to I selects all the filtered out rows in between.

Expected behavior is to select only the rows not filtered out.  As is, this
makes OpenOffice Calc much less useful to my employer for trying to take a
subsection of a spreadsheet and copy it to a report.