Problem description: formula no longer works - regular expression not interpreted correctly
Steps to reproduce:
1. ensure regular expressions are enabled in options
2. enter a formula which uses regular expressions, e.g. =countif(A2:A5,".*Y.*") into cell A1
3. type Y in cell A2
Current behavior: doesn't count it
Expected behavior: counts it
NB: =countif(A2:A5,"Y") works as expected
Platform (if different from the browser):
Browser: Mozilla/5.0 (X11; Ubuntu; Linux i686; rv:13.0) Gecko/20100101 Firefox/13.0.1
Created attachment 67313 [details]
test file with regex
Formula with regular expressions no longer works.
These formulae gives the same results, option enabled or not.
Seen with new files created with 220.127.116.11, also with files created with previous versions and opened with 18.104.22.168.
This file created with 22.214.171.124 gives expected result while opened with 3.6.1.
So option is enabled and correctly stored in .xml
I most likely found this problem.
Please note that even with my fix you need a Ctrl+Shift+F9 for a manual hard recalc.
Markus Mohrhard committed a patch related to this issue.
It has been pushed to "master":
delegating a constructor can't work like this, fdo#55033
The patch should be included in the daily builds available at
http://dev-builds.libreoffice.org/daily/ in the next 24-48 hours. More
information about daily builds can be found at:
Affected users are encouraged to test the fix and report feedback.