Issue 105415 - Need "Find all†option in Find dialog
Summary: Need "Find all†option in Find dialog
Status: CLOSED DUPLICATE of issue 94089
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: version58
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: spreadsheet
QA Contact: issues@sc
Depends on:
Reported: 2009-09-28 10:27 UTC by walidz
Modified: 2009-09-29 08:26 UTC (History)
1 user (show)

See Also:
Latest Confirmation in: ---
Developer Difficulty: ---

calc file (11.00 KB, application/vnd.oasis.opendocument.spreadsheet)
2009-09-28 10:28 UTC, walidz
no flags Details
screen shot of excel "find and replace (56.77 KB, text/plain)
2009-09-28 10:29 UTC, walidz
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description walidz 2009-09-28 10:27:28 UTC
In ms excel, if I want to search for a text in an Entire Workbook ,
the results are listed in a List Box , so that I can review them easily in ANY
ORDER  (very intuitive) , however Calc does not have this feature; it has the
classic way of find and find next , 

Another benefit of this feature is that " it acts like a query" ;
in order to clarify this, I attached a XLS file that contains a monthly overtime
hours for employees.
now if I want to know "employee A" in which months he has overtimes hours. 
in ms excel  : i can search for "employee A" in the entire workbook , and I
immediately know that he has overtime hours in Jan./Feb/April but not in march ,
however in Calc it is really very difficult to fetch this results

1- Open the attached file in ms EXCEL
2- press control+F to open the "Find and Replace" dialog 
3- enter text : employee A
4- in the "within option" choose workbook
5- then press find all 

6- see the attached picture
Comment 1 walidz 2009-09-28 10:28:47 UTC
Created attachment 65005 [details]
calc file
Comment 2 walidz 2009-09-28 10:29:38 UTC
Created attachment 65006 [details]
screen shot of excel "find and replace
Comment 3 dtardon 2009-09-29 08:25:40 UTC

*** This issue has been marked as a duplicate of 94089 ***
Comment 4 dtardon 2009-09-29 08:26:11 UTC