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".
Can't repro with Version: 7.0.0.1 (x64) Build ID: 04ba7e3f1e51af6c5d653e543a620e36719083fd CPU threads: 12; OS: Windows 10.0 Build 18363; UI render: Skia/Raster; VCL: win Locale: ru-RU (ru_RU); UI: en-US Calc: CL (In reply to Fiable.biz from comment #0) > I'm asked below whether OpenGL is enabled. But I can't see such an option in > "Tools ▸ Options ▸ LibreOffice ▸ View". Much more important is if *regular expressions* are enabled on Options->Calc->Calculate. By default, wildcards are enabled, not regular expressions. Curiously, you had cited help for v.6.2, while indicated version 6.4; help for v.6.4 [1] already contains additional notice about "With regular expressions enabled"; but even for 6.2, it's mentioned there: "You can switch the automatic evaluation of regular expression on and off in - LibreOffice Calc - Calculate". So please check the setting. Is it enabled for you? [1] https://help.libreoffice.org/6.4/en-US/text/scalc/01/04060109.html?DbPAR=CALC#hd_id3158407
Thank you very much. It was not enabled.