---- Original Message ---- From: Larry To: Harold Fuchs Sent: Thursday, December 21, 2006 3:26 PM Subject: Re: [users] Re: Finding Several Numbers in Calc (was Re: [users] [moderated] YOU MUST GIVE A SUMMARY HERE)
> Sorry to keep 'pestering' you Harold, you seem to be the only person > who has a grasp of my concern. I am using version 2.0.4 of OO on > Windows XP. > I guess the best way to explain my problem is to show you my > spreadsheet. > > 579374448 > 2416253949 > 81524303132 > 1713273237 > > > That example is just 4 rows of approximately 50. When I enter (try) > any of your suggestions into the "find", the result is a hi-lite of > only one number. Say for example I need to find the numbers 8, 15, > 16, 25, 32 and 49. I can search for 8, then search for 15, then 16, > etc., one at a time which is time consuming, I would like "find" to > hi-lite all six numbers all at once, like this: > 579374448 > 2416253949 > 81524303132 > 1713273237 > > > Oh and yes, the numbers are all whole numbers, they are not formulas > or the results of formulas. > Thanks again and I really do appreciate you assistance > > Larry, > Brampton, Ontario, Canada > > Just to refresh; > > ---- Original Message ---- > From: Larry > To: Harold Fuchs > Sent: Wednesday, December 20, 2006 2:53 PM > Subject: [users] Re: Finding Several Numbers in Calc (was Re: [users] > [moderated] YOU MUST GIVE A SUMMARY HERE) > > I wrote: > > Hi Harold, and thanks for the info. Unfortunately (what am I doing > wrong here?) when I entered my search numbers: > ^3$|^7$|^10$|^22$|^35$|^49$ according to your suggestion, the only > result I get is it finds only the first number "3". > Please assist, if you don't mind. > Thanks > Larry > > You replied with; > > Are the numbers displayed as integers on the screen? Trying to find > "^7$" (no quotes) if the actual value shown is 7.3 won't work; if you > want to find seven or seven point something the easiest way, although > not the most concise, is to find ^7$|^7\..*$ The second part of > that, after the bar, is caret 7 backslash dot dot asterisk dollar. > Note the two dots - "\." means "an actual dot" and ".*" means "any > number, including zero, of any character". > > Are the numbers the results of formulae in the cells you are > searching? If so, the technique doesn't work and I'm afraid I don't > know how to do what you want. Anybody ??? > > Also, what version of OOo are you using and on what version of which > Operating System? It is conceivable that Regular Expressions are > broken in some versions. > > Harold Fuchs > London, England I'm confused. This has stopped working on my system. When I sent you my first e-mail it worked exactly as I said. Now it doesn't. Sorry. Harold Fuchs London, England
