https://bugs.documentfoundation.org/show_bug.cgi?id=147669
Bug ID: 147669
Summary: Calc - MATCH gives wrong result with an inline array
Product: LibreOffice
Version: 7.3.0.3 release
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
See attached.
=MATCH("2",{2;3},0) gives #N/A (incorrect)
=MATCH("2",C4:D4,0) gives 1 (correct) if C4=2 and D4=3
Steps to Reproduce:
See attached
Actual Results:
See attached
Expected Results:
See attached
Reproducible: Always
User Profile Reset: No
Additional Info:
I need the first parameter to MATCH be a string because in my application it is
a regular expression.
Version: 7.3.0.3 (x64) / LibreOffice Community
Build ID: 0f246aa12d0eee4a0f7adcefbf7c878fc2238db3
CPU threads: 4; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: en-GB (en_GB); UI: en-GB
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
