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]
