Issue 89047 - Regular expressions/whole cell matching in MATCH: recalculation
Summary: Regular expressions/whole cell matching in MATCH: recalculation
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 2.4.0
Hardware: All All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: oc
QA Contact: issues@sc
URL:
Keywords: regression
Depends on:
Blocks:
 
Reported: 2008-05-06 00:10 UTC by drking
Modified: 2013-08-07 15:15 UTC (History)
1 user (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this issue.
Description drking 2008-05-06 00:10:24 UTC 
A1, A2 have "blue", "red" 
A3 has =MATCH("r.d";A1:A2;0) 

This should return 2 if regular expressions are enabled and #N/A if not. 

In OOo2.4 WinXP I've found that if I enable/disable regular expressions the 
result does not change. Even if I recalculate manually using F9 or Ctrl-Shift-
F9 the result does not change. (Other formulae, eg =RAND(), do recalculate).

The only way to get the change seems to be to edit A1 or A2.

I'm almost sure this did not happen in OOo2.3 - that recalculation always 
occurred.

Another (experienced) user has confirmed the behaviour on a separate machine. 
Quite a serious problem I think - possibly P2.
Comment 1 mariosv 2008-05-06 23:28:31 UTC 
In 2.4 there are to calculation modes:
- F9 calc only modified cells.
- Shift+Ctrl+F9 recalc all cells.
Try the second mode.
Comment 2 drking 2008-05-07 05:53:53 UTC 
>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)
Comment 3 ooo 2008-06-25 16:40:55 UTC 
This regressions seems to be caused by the lookup cache introduced with the fix
of issue 81336.
Comment 4 ooo 2008-06-27 18:21:18 UTC 
In cws calcfixes30:

sc/inc/document.hxx  1.112.60.1
sc/source/core/data/documen2.cxx  1.73.60.1
sc/source/core/data/document.cxx  1.88.84.1
Comment 5 ooo 2008-07-02 12:57:29 UTC 
Reassigning to QA for verification.
Comment 6 oc 2008-07-03 15:23:48 UTC 
verified in internal build cws_calcfixes30
Comment 7 sgautier.ooo 2008-09-09 14:47:49 UTC 
Verified in OOO300m5 - Closing - Sophie