[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 #8 from Gauthier <g.guerin at posteo.net> ---
Hi,

I'm experiencing a bug that "feels" similar to this one. I'm happy to file
another bug report if that's better.

After the update to to LO 7.2.1 (from 7.1.x), MATCH formulas started to display
N/A whereas the value definitely exists.

I have a row with a list of value. I look for the minimum value in that row
using the MIN function, and then wants to know in which column that value is
found so I use the MATCH function over that same row, using the result of the
MIN function as the Search Criteria. So this means the value has to exist (and
it used to work fine before).

I have been able to make the MATCH function work by displaying more decimals on
the cell where the minimum is found (which value is used as the Search Criteria
in MATCH) until there is no more rounding. So it seems MATCH (and maybe other
formulas) does not if that *displayed* values are rounded, which is very odd! 

Screenshots attached.

-- 
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/20210923/fdab4d5f/attachment-0001.htm>