[Libreoffice-bugs] [Bug 40967] New: Array formulas involving IF and OR do not work

[bugzilla-daemon at freedesktop.org]

https://bugs.freedesktop.org/show_bug.cgi?id=40967

           Summary: Array formulas involving IF and OR do not work
           Product: LibreOffice
           Version: LibO 3.4.3 release
          Platform: x86 (IA32)
        OS/Version: Linux (All)
            Status: NEW
          Severity: major
          Priority: medium
         Component: Spreadsheet
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: reto.schoch at gmail.com


The attached Calc-file has an example of an array formula in E2 involving IF
and OR, which perfectly works with OpenOffice ever since.

Using it with Libreoffice 3.4.3 turned out that the formula always returns the
value TRUE, even if the value in D2 does not match with any value in the array
of A2:A4 oder B2:B4.

This should be fixed as this is a quite often used method to validate data or
generate data values continued to use in other formulas.

Thx for checking!

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.