Dear Sirs,
I am an electronic engineer called Teodorico Augusto Eberle. I work in my
company called MCDI do Brasil that sells and gives technical support to
Alarm Monitoring Systems.
I am a user of OpenOffice and I´ve found a very serious bug, descrived
below, at the calc sheet program.
The message was sent to Frank, at Sun Microsystems first, using the link of
OpenOffice homepage, now is being sent again to the addresses Mr. Frank told
me about.
My best regards,
MCDI do Brasil
Eng. Teodorico
[EMAIL PROTECTED]
Bug description summary:
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:
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 in 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 the lines only with this value. You then 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. 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.
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 '1' value!!!
The 'b' and 'c' named lines shouldn´t be changed!!!
Please fix this problem.
It exists since version 1.0 until now, at the 1.1.3 of OpenOffice.
My best regards,
MCDI do Brasil
Eng. Teodorico Augusto Eberle
Technical director
[EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
