If you drag a value from one row to another to create copies when a row filter
is active, this value will be copied to all rows between target and destination,
regardless of the filter state.

For example, my filter shows the rows 1, 2, 5, 10 and 100. If I grab a value
from A1 to A100 while holding control, I expect that this value will be copied
to A2, A5, A10 and A100 but OO overrides all values from A1 to A100 with the
value of A1. If you drag it a little bit lower, it will override all rows from
A2 to A65536 with a copy of A1. The only feedback to the user that he/she is
about to modify all these rows, even the invisible ones, is a small tooltip that
appears near to the mouse pointer. The same effect occurs with auto increment
operations.

Since OO is a WYSIWYG app., it is natural that only the visible things are
affected by any visual operation unless stated otherwise.