I have this list:
Test	Value
1	A
2	B
3	C
2	V
5	X
6	A
2	T
1	H

when apply an automatic filter and select show only "2" value this show:

Test	Value
2	B
2	V
2	T

Then when the data is filteres if I drag the rightbottom rectangle to replace 
all value to "B" (first value in correspondance of first value 2 column test): 

Test	Value
2	B
2	B
2	B

but when remove filter this is the result:
Test	Value
1	A
2	B
3	B
2	B
5	B
6	B
2	B
1	H

instead this (only the value in correspondance of "2" is changed):

Test	Value
1	A
2	B
3	C
2	B
5	X
6	A
2	B
1	H

All value is changed also those hiding from the filter!!!

Openoffice works differently from excel and this is a very big problem...

Sergio