[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 12:57:19 UTC 2021
https://bugs.documentfoundation.org/show_bug.cgi?id=144142
--- Comment #4 from Andreas Blochberger <andreas at netts.org> ---
(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
--
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/634ee31d/attachment-0001.htm>
More information about the Libreoffice-bugs
mailing list