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: [email protected]
ReportedBy: [email protected]
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.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
