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

bugzilla-daemon at bugs.documentfoundation.org bugzilla-daemon at bugs.documentfoundation.org
Sat Aug 28 15:54:46 UTC 2021


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

--- Comment #5 from Uwe Auer <uwe at franke-auer.de> ---
(In reply to Andreas Blochberger from comment #4)
> (In reply to Uwe Auer from comment #3)
> > Using =MATCH(A15;VALUE(C2:C13);0)has the same effect as reformatting to
> > number of significant digits. 
> That works. Thanks for the workaround

My comment wasn't meant as a workaround, but as a hint to developers, where to
start their search in code for the bug. Anyway: I'm glad that the note serves
as workaround as well.

-- 
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/a071f4fe/attachment.htm>


More information about the Libreoffice-bugs mailing list