Calc Guide

to 2. Change the number of decimal places, and, if necessary, uncheck the Precision
as shown box on the same page, and the spreadsheet will display as expected.
Using regular expressions in functions
A number of functions in Calc allow the use of regular expressions: SUMIF,
COUNTIF, MATCH, SEARCH, LOOKUP, HLOOKUP, VLOOKUP, DCOUNT, DCOUNTA,
DSUM, DPRODUCT, DMAX, DMIN, DAVERAGE, DSTDEV, DSTDEVP, DVAR, DVARP,
DGET.
Whether or not regular expressions are used is selected on the Tools > Options >
OpenOffice.org Calc > Calculate dialog.
Figure 163: Enabling regular expressions in formulas
For example =COUNTIF(A1:A6;"r.d") with Enable regular expressions in
formulas selected will count cells in A1:A6 which contain red and ROD.
Additionally if Search criteria = and <> must apply to whole cells is not
selected, then Fred, bride, and Ridge will also be counted. If that setting is selected,
then it can be overcome by wrapping the expression thus:
=COUNTIF(A1:A6;".*r.d.*").
Figure 164: Using the COUNTIF function
Chapter 7 Using Formulas and Functions 191