https://bugs.documentfoundation.org/show_bug.cgi?id=134774
Bug ID: 134774
Summary: | (or) seem no to work in regular expressions inside a
function
Product: LibreOffice
Version: 6.4.4.2 release
Hardware: All
OS: Linux (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
A "or" sign (|) in regular expression inside a function seems not to be
correctly interpreted and returns "#N/A".
Steps to Reproduce:
1. Enter "a" in cell J43.
2. Enter "b" in cell J44.
3. Enter "=MATCH("a|c";J43:J44;0)" in cell K43.
Actual Results:
#N/A
Expected Results:
1
Reproducible: Always
User Profile Reset: Yes
Additional Info:
Although providing only one example, the documentation says regular expressions
are supported:
https://help.libreoffice.org/6.2/en-US/text/scalc/01/04060109.html?DbPAR=CALC#hd_id3158407
I'm asked below whether OpenGL is enabled. But I can't see such an option in
"Tools ▸ Options ▸ LibreOffice ▸ View".
--
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
