[Libreoffice-bugs] [Bug 112404] New: SEARCH function of Calc called via the FunctionAccess service does not apply HOST-USE-REGULAR-EXPRESSIONS if true.

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=112404

            Bug ID: 112404
           Summary: SEARCH function of Calc called via the FunctionAccess
                    service does not apply HOST-USE-REGULAR-EXPRESSIONS if
                    true.
           Product: LibreOffice
           Version: 5.3.4.2 release
          Hardware: All
                OS: All
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: BASIC
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: jag at psilosoph.de

Created attachment 136258
  --> https://bugs.documentfoundation.org/attachment.cgi?id=136258&action=edit
The demo mentioned in the report

If the SEARCH function of Calc is called from BASIC user code it ignores the
setting of 'Enable regular expressions in formulae' (the value of the property
HOST-USE-REGULAR-EXPRESSIONS) and only searches for literals.

I did not yet test if the other functions specified to evaluate the mentioned
property show the bug too. 

I also did not test if different SDK also produce the misbehaviour. 

This is a REGRESSION. All the versions of LibO I could test up to V 5.2.3.3 did
not show the bug. AOO up to V4.1.3 also works as expected. 
The oldest version I could test whih showed the bug was V5.3.4.2. The bug is
still present in V5.4.1.2.

The OS I tested on is Windows 10. The bit-width of LibO V5.4.1.2 is 64. All the
other versions I tested are from PortableApps packages and use 32 bit-width.

Steps to reproduce:
A
1 Open the attached example with Calc of V5.2.3.3 or older.
2 Check for 'Enable regular expressions in formulae' being ENABLED.
3 Verify the expected results in column D as correct.
4 Compare with the results of the user function in column C.
5 Check the function code.
6 Close the file without saving.
B
1 Open the file  again with V5.3.4.2 or more recent.
2 (As above)
3 Compare columns C and D. Verify the claimed errors.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20170915/2a401596/attachment.html>