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 -- OOo/SO Calc core developer. Number formatter bedevilled I18N transpositionizer. GnuPG key 0x293C05FD: 997A 4C60 CE41 0149 0DB3 9E96 2F1A D073 293C 05FD --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
