[Libreoffice-bugs] [Bug 144142] MATCH returns #N/A if found value is from a formula

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=144142

--- Comment #2 from Uwe Auer <uwe at franke-auer.de> ---
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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20210828/34284d55/attachment.htm>