Issue 67659

Summary: Data hidden by filter will be changed by "replace"
Product: Calc Reporter: cedgia <ced>
Component: editingAssignee: spreadsheet <spreadsheet>
Status: CLOSED DUPLICATE QA Contact: issues@sc <issues>
Severity: Trivial    
Priority: P3 CC: issues, oc, rainerbielefeld_ooo_qa
Version: OOo 2.0.3Keywords: oooqa
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: DEFECT Latest Confirmation in: ---
Developer Difficulty: ---

Description cedgia 2006-07-21 13:21:15 UTC
I have this list:
Test	Value
1	A
2	B
3	C
2	V
5	X
6	A
2	T
1	H

when apply an automatic filter and select show only "2" value this show:

Test	Value
2	B
2	V
2	T

Then when the data is filteres if I drag the rightbottom rectangle to replace 
all value to "B" (first value in correspondance of first value 2 column test): 

Test	Value
2	B
2	B
2	B

but when remove filter this is the result:
Test	Value
1	A
2	B
3	B
2	B
5	B
6	B
2	B
1	H

instead this (only the value in correspondance of "2" is changed):

Test	Value
1	A
2	B
3	C
2	B
5	X
6	A
2	B
1	H

All value is changed also those hiding from the filter!!!

Openoffice works differently from excel and this is a very big problem...

Sergio
Comment 1 Rainer Bielefeld 2006-07-21 16:06:51 UTC
This is a DUP of Issue 43613, which is declared to be a DUP of closed Issue
2977, where we have the note "Overwriting of hidden cells during pasting is
handled by #i33851#". But no "Normal User" can know anything concerning
existence and progress of #i33851#, so may be we should leave this issue open
(Remind? Task?) so that users see that this problem is not WONTFIX or forgotten,
votes are possible and so on? Developers, pls. decide!
Comment 2 frank 2006-07-25 15:55:38 UTC
So this Issue is a double to Issue 33851 and is now closed as such.

*** This issue has been marked as a duplicate of 33851 ***
Comment 3 frank 2006-07-25 15:55:55 UTC
closed double