To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=52355 Issue #:|52355 Summary:|paste to a filtered selection fills also the |unselected cells Component:|Spreadsheet Version:|OOo 1.1.3 Platform:|PC URL:| OS/Version:|All Status:|UNCONFIRMED Status whiteboard:| Keywords:| Resolution:| Issue type:|DEFECT Priority:|P3 Subcomponent:|editing Assigned to:|spreadsheet Reported by:|teodoricoaeberle
------- Additional comments from [EMAIL PROTECTED] Fri Jul 22 13:34:54 -0700 2005 ------- 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 [EMAIL PROTECTED] --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]