If I remember correctly excel does the same exact thing.
Shari
Dan Lewis was roused into action on 7/22/2005 8:07 PM and wrote:
On Friday 22 July 2005 01:35 pm, MCDI do Brasil - Suporte wrote:
Hi, Heike,
I can see that this message is still uknown by the OOffice people...
Now I an starting to understand why the bugs take so long to be
fixed.... This one exists since the first version.
About Data loss: suppose that you have a 2 thousand lines calc sheet,
with all your sales to all clients, and you need to change one
product name, just to fix it You turn on a filter and select the name
you want to fix, so you can fix all the lines with this name in one
operation. Suppose also, that there are only two lines with this
product name: the first and the last lines. You change one, copy it
and paste it to the two lines, and save the file. There you are. ALL
2 thousand lines with the product names now are equal to the two you
pasted. Isn´t this a big data loss?
My best regards,
Teodorico
<snip>
If you are just changing a product name, why couldn't you do a find
and replace for that product name?
Similarly, here is a possible work-around: copy the rows you want
to change to another sheet. Make your changes, and then move these
changes back to their original rows.
Dan
