Brian Barker wrote: > At 03:12 24/10/2008 +0000, Girard Aquino wrote: >> I got the new column, ... > > Good-oh! > >> ... but I am having difficulty representing characters in the >> countif(). I am using =COUNTIF(D8:D133;"\"). > > That will count those cells which contain a backslash and nothing > else, of course. Is that what you want? Since my example didn't use > any backslashes, I can't guess what you are trying to do. > >> i tried to replace the formatting of the new column into text, ... > > That's unlikely to be your problem, I think. Anything potentially > containing a backslash has to be text, doesn't it? > >> ... but can't get the desired result. I know it's probably a problem >> with my syntax. > > Are you trying to search for cells containing a backslash, rather than > those consisting of a backslash? That's more complex. Note that the > results will depend on your setting at Tools | Options... | > OpenOffice.org Calc | Calculate | Enable regular expressions in > formulas. And a backslash is a peculiarly confusing character to > choose in your scheme (if that is what you have done), since it is > also the escape character for regular expressions. > I've noticed that enabling regular expressions in formulas has to be ticked everytime you run OOo. when you close it, the option is unticked. is this really the case for that option of a bug in OOo 3.0 on XP? at first i thought there was something wrong with the formula since I got zeros on the cells when I opened the file again. one would think that ticking this option once should do the trick and not have to do it every time. > I trust this helps. > > Brian Barker > > > --------------------------------------------------------------------- > To unsubscribe, e-mail: [EMAIL PROTECTED] > For additional commands, e-mail: [EMAIL PROTECTED] > > >
_________________________________________________________________
