To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=89047
User drking changed the following: What |Old value |New value ================================================================================ Summary|Regular expressions in fun|Regular expressions/whole |ction: recalculation |cell matching in MATCH: re | |calculation -------------------------------------------------------------------------------- ------- Additional comments from [EMAIL PROTECTED] Wed May 7 04:53:53 +0000 2008 ------- >Shift+Ctrl+F9 recalc all cells. >Try the second mode. >From my first post: "Even if I recalculate manually using F9 or Ctrl-Shift- F9 the result does not change." I've now adjusted the subject, because this seems not to affect other functions that respond to regex, such as HLOOKUP and COUNTIF. These functions do recalculate following a change in regex setting. The problem also applies to changes in 'whole cell matching' (set on same dialog as regex): A1, A2 have "Fred", "red" A3 has=MATCH("red";A1:A2;0) --------------------------------------------------------------------- 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]