This bug exists since several old versions (not recorded) until now, at the
1.1.3 of OpenOffice, in Windows or Linux environment.

Description: if there are lines selected by a filter in a calc sheet and you
paste data to a column of the selection, the same data is also filled in the
lines that are NOT selected, but exist between the selected ones.

 Example:

Create a calc sheet with two columns, starting at the 'A1' cell, with the
following data:

 Name    Value
 a           1
 b           2
 c           3
 a           4

 Click in the 'A1' ("Name") cel;
 Select at the menus: "Data" | "Filter" | "Auto-filter";
 Click at the down arrow for data selection, created by the filter at the 
 right of the "Name" word at the column "Name" and select the 'a' value, to 
 select only the lines with this value. You will see only the lines 
 below:

 Name  Value
 a         1
 a         4

 As you can see, the filter selected and showed only the lines with the 'a' 
 Name and this is correct.

 Now right-click over the cell with the value '1', select "Copy" to make a 
 copy of this data (it doesn´t matter what is the data you are copying, the 
 results will be the same);

 Select the two cels of the column "Value" - the one with '1' and the one 
 with the '4' and paste the copied '1' to the two, confirming the warning 
 about being filling cels already with values. It doesn´t matter what is 
 the data you are pasting, the results will be the same.

 At this time, you will have the following data at your screen:

 Name   Value
 a          1
 a          1

 Finally, click on the blue down arrow at the right of the "Name" word and 
 select "All" at the pull-down selection list of the filter, to see all 
 data again. You will see the following:

 Name  Value
 a         1
 b         1
 c         1
 a         1

 As you can see, ALL lines between the selected oned by the filter had the 
 values changed!!!! This is VERY DESTRUCTIVE. Only the lines shown at the 
 screen should be filled with the pasted '1' value!!!
 The 'b' and 'c' named lines shouldn´t be changed!!!

 There are two hidden lines between the two shown, at this example, but there
can be lots of 'hidden' lines between the selected ones, in a big sheet, and all
will be changed to the pasted value. 

In Non-contiguous selections: if there are several non-contiguous lines
selected, all the lines between all the selected lines are also filled with the
pasted value.

 Please fix this problem.


 Thanks and my best regards,

 MCDI do Brasil
 Eng. Teodorico Augusto Eberle
 Technical director
 teoeberle@hotmail.com