Apache OpenOffice (AOO) Bugzilla – Issue 105415
Need "Find all†option in Find dialog
Last modified: 2009-09-29 08:26:11 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
Created attachment 65005 [details] calc file
Created attachment 65006 [details] screen shot of excel "find and replace
duplicate *** This issue has been marked as a duplicate of 94089 ***
closing