On Thu, 2005-02-10 at 14:49 -0500, Laurent Duperval wrote: > Laurent Duperval wrote: > > > For example, if cell A1 contains "S1" > > > > =countif(A1;"S1") > > > > gives 1 > > > > = countif(A1;".*") > > > > gives 0 > > > > Looks like the RE parser is broken. -( > > > > After further investigation, it looks like it doesn't work in that > specific spreadsheet. If I create a new spreadsheet and use the above > values, everything works as expected. > > I tried adding a new sheet to my document to see, and I get the same > problem. I'm not sure what the problem is.
Is the mal-functioning spreadsheet one created in OOo or is it a MS Excel one that you imported? You may want to check your Tools->Options just to see if the regular expressions under Spreadsheet->Calculate is selected? Regards Jonathon
