https://bugs.documentfoundation.org/show_bug.cgi?id=144142
--- Comment #8 from Gauthier <[email protected]> --- 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.
