Issue 92707 - Find&Replace operations should not touch filtered rows.
Summary: Find&Replace operations should not touch filtered rows.
Status: CLOSED DUPLICATE of issue 108087
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 2.4.1
Hardware: All All
: P3 Major with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2008-08-12 14:23 UTC by docb
Modified: 2017-05-20 09:52 UTC (History)
3 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Testcase - use 'change all' for force the problem (244.50 KB, application/vnd.ms-excel)
2008-08-12 14:59 UTC, docb 		no flags Details
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description docb 2008-08-12 14:23:44 UTC 
I have a spreadsheet with the autofilter set.
I filter for all values 2206332, which are properly shown.
Now I search&replace  2206332 with 2545332N 

Result: The values are changed, BUT the hidden values 2206332N are changed as
well to 2535332NN

To my understanding the hidden values should not be changed!
Comment 1 frank 2008-08-12 14:41:34 UTC 
double to numerous Issues mainly to Issue 33851 which is fixed for OOo3

Please use the query facilities before submitting Issues or RFE's

Frank

*** This issue has been marked as a duplicate of 33851 ***
Comment 2 frank 2008-08-12 14:41:57 UTC 
closed double
Comment 3 docb 2008-08-12 14:59:43 UTC 
Created attachment 55719 [details]
Testcase - use 'change all' for force the problem
Comment 4 docb 2008-08-12 15:00:56 UTC 
oops...trust me that I looked for the problem beforehand
Comment 5 erack 2008-08-14 21:59:43 UTC 
Find&Replace was not tackled by fixing issue 33851, reopening this issue here.
Comment 6 erack 2008-08-14 22:09:36 UTC 
Reassigning, targeting.
Comment 7 docb 2008-08-18 14:06:38 UTC 
Can we change the issue type back to 'defect'?
The usage of find&Replace on filtered content leads to unexpected (aka wrong) 
results, so I would not see this as an enhancement.
Thanks
Axel
Comment 8 Rainer Bielefeld 2013-07-29 15:27:09 UTC 
We have some patches in "Bug 108087 - Find doesn´t work with filtered data"
We have an Enhancement request in "Bug 90901 - Add option "also find in hidden cells"

This one is not "trivial" but a showstopper for any power user.

Eike is no longer active in AOO, so Assignee back to list
Comment 9 Rainer Bielefeld 2014-03-03 10:05:19 UTC 
I mark this one as DUP of "Bug 108087 - Find doesn´t work with filtered data" because there we have a draft for a patch.

*** This issue has been marked as a duplicate of issue 108087 ***