Sometime I m using lots of formulas in my open office file. Especially in spreadsheet. But i don’t know why it doesn’t work out sometime. Some guy in a forum said it is some kind of bug but in another forum wrote about changing the option in the tool.
I believe the second one is most reliable. Like today, I m using countif(range;criteria) in my calc file.
=countif(B2:B50;”Guru.*”)
That’s mean I want to count how many data that contains the word Guru in front of each text.
It returns zero or nothing. But the data show that at least 30 row of data containing Guru.
Then I go to Tools Option – OpenOffice.org Calc – Calculate.
Check list the option Search Criteria = and <> must apply to whole cells and Enable regular expressions in formulae
That’s two option gonna make my countif formulae worked.
Leave a Reply