https://bugs.documentfoundation.org/show_bug.cgi?id=101875
Bug ID: 101875
Summary: EDITING: FIND and SEARCH functions don't use an array
as first parameter in array formula
Product: LibreOffice
Version: Inherited From OOo
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: miguelange...@libreoffice.org
Created attachment 127134
--> https://bugs.documentfoundation.org/attachment.cgi?id=127134&action=edit
File showing the bug
With a formula like
=SUMPRODUCT(NOT(ISERROR(FIND(E2:E3;A2:C11))))
FIND doesn't find for values in E2:E3, looks if it finds some of them.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs