On Sat, 2005-06-18 at 22:33 -0600, Doug Thompson wrote: > Bruce Ardern wrote: > > Hi Doug, > > > > thanks for your reply. I had used the "More >>" button before but still > > wasn't able to do what I wanted to do. > > > > In the example that I quoted =IF($Cards121.$B$6>$Cards121.$E$6;2, (in > > part) I have clicked on the cell and in the "Find & Replace" box > > searched for 21 and requested change to 12. I have "Current Selection > > only" ticked and a dot in "Formulas" and a dot in "Search Rows". I have > > also tried with "Entire Cells" ticked. I have also tried searching for > > the whole sheet reference $cards121 with no luck either. > > > > When I click either "Find" or "Replace" I get a box saying the Oo.org > > Calc has searched to the end of the sheet etc. and nothing happens to > > the target cell. I have alternatively clicked "Replace All" and get the > > return "Search Key not Found". I am using Oo 1.1.2 > > I don't know and can't test if OOo1.1.2 function is up to that of 1.1.4 > or the newer 1.9.xx betas. First suggestion is to update and see if > that gets you beyond this sticking point.
Hi Bruce, It is certainly possible in the 1.9.104 version I am using. Simply click on the Find and Replace menu option, click on the >>More options and make sure you are searching on "Formula". If okay, then do your search and replace and it should work fine. Regards Jonathon -- OOo Tips (RSS) - http://mindmeld.cybersite.com.au/tips.rss OOo Knowledgebase - http://mindmeld.cybersite.com.au/ Cybersite Consulting - http://www.cybersite.com.au/ Training4Linux - http://www.training4linux.com --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
