Formula issue

[Hegetsu]

Let say for example I have formula =COUNTIF(A1; "E*") in excel. The * symbol does not work in calcoffice. Is there any way to go round that problem?

[robleyd]

From the offline help - F1 and search COUNTIF:

COUNTIF
Returns the number of cells that meet with certain criteria within a cell range.
The search supports regular expressions. You can enter "all.*", for example to find the first location of "all" followed by any characters. If you want to search for a text that is also a regular expression, you must precede every character with a \ character. You can switch the automatic evaluation of regular expression on and off in Tools - Options - OpenOffice Calc - Calculate.

Search the offline help for regular expressions;list of for more on regular expressions