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: [email protected]
Reporter: [email protected]
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
