To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=16786
------- Additional comments from prowlerx...@openoffice.org Fri Jan 8 15:23:09 +0000 2010 ------- I agree, is a defect, a workaround is to use SUBSTITUTE function (in Italian SOSTITUISCI) that substitute the characters used in regular expression (* or + with \* and \+) to be used with the functions like HLOOKUP or COUNT.IF (CONTA.SE($B$3:$B$1000;"="&SOSTITUISCI(SOSTITUISCI(L3;"*";"\*");"+";"\+")) ). A solution could be a new function like HLOOKUP.NOREGEXPR where the text is always considered plain text or add an optional parameter in the function (1 or 0 to have or not to have regular expression considered) but as suggested in Italian list this could give some compatibility problems with microsoft office --------------------------------------------------------------------- Please do not reply to this automatically generated notification from Issue Tracker. Please log onto the website and enter your comments. http://qa.openoffice.org/issue_handling/project_issues.html#notification --------------------------------------------------------------------- To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org