On Thu, 2005-08-11 at 07:14, Eike Rathke wrote: > Hi Fred, > > On Wed, Aug 10, 2005 at 18:29:15 -0500, Fred Grant wrote: > > > I seem to remember solving a similar problem to your "pears" example by > > enabling regular expressions in calc. I don't think it will solve your > > larger problem as the only strings I've had it count are at the > > beginning of the cell, eg it wouldn't count "ripe pears". > > Which could be solved by either defining the regular expression as > ".*pears.*" or disabling the Tools.Options.Spreadsheet.Calculate setting > "Search criteria = and <> must appy to whole cells" for the entire > document. > > Eike Thanks for the excellent tutorial!
Fred --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
