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

Reply via email to