https://bugs.documentfoundation.org/show_bug.cgi?id=144142
--- Comment #2 from Uwe Auer <[email protected]> --- No Repro in Version: 7.1.5.2 / LibreOffice Community Build ID: 85f04e9f809797b8199d13c421bd8a2b025d52b5 CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: kf5 Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded Repro Version: 7.2.0.4 / LibreOffice Community Build ID: 9a9c6381e3f7a62afc1329bd359cc48accb6435b CPU threads: 8; OS: Linux 5.3; UI render: default; VCL: kf5 (cairo+xcb) Locale: en-US (en_US.UTF-8); UI: en-US Calc: threaded The problem seems to be related to the formatting of the cells in column C. Using a format showing the significant decimals results in MATCH working correctly/as expected (after recalculation). Procedure: - change format for data cells in column C to "#,##0.000 [$€-407];[RED]-#,##0.000 [$€-407]" (3 decimals, which equals significant digits of value in A15) - Recalculate using F9 or Data -> Calculate -> Recalculate (F9) => MATCH yields expected value 4 -- You are receiving this mail because: You are the assignee for the bug.
