Bug 40967 - Array formulas involving IF and OR do not work
Summary: Array formulas involving IF and OR do not work
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.4.3 release
Hardware: x86 (IA32) Linux (All)
: medium major
Assignee: Markus Mohrhard
Whiteboard: target:3.5 target:3.4.5
Depends on:
Reported: 2011-09-17 06:46 UTC by Reto
Modified: 2012-01-17 13:46 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Calc-file with an example proving evidence of the bug (8.04 KB, application/vnd.oasis.opendocument.spreadsheet)
2011-09-17 06:54 UTC, Reto

Note You need to log in before you can comment on or make changes to this bug.
Description Reto 2011-09-17 06:46:48 UTC
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!
Comment 1 Reto 2011-09-17 06:54:05 UTC
Created attachment 51291 [details]
Calc-file with an example proving evidence of the bug
Comment 2 tester8 2011-09-20 11:28:07 UTC
Reproduced with

LO 3.4.3 OOO340m1 (Build:302)
Ubuntu 10.04.3 x86
Linux 2.6.32-33-generic Russian UI
Comment 3 Petr Mladek 2011-11-01 07:57:13 UTC
It is a regression against LO-3.3. I see it in 3.4.0 and master.

IMHO, important is the comparison against a set of cells, e.g D3=A$2:A$4. It works when you compare just against one cell, e.g. D3=A$2.
Comment 4 Markus Mohrhard 2011-11-01 08:27:26 UTC
I'm taking a look at it.
Comment 5 Markus Mohrhard 2011-11-01 09:26:15 UTC
pushed a fix to master and send a patch for 3-4 to the ML
Comment 6 Reto 2012-01-03 11:58:12 UTC
The Release Notes for Releases/3.4.5/RC1 contains in the following item a wrong bug ID:

• boolean values are valid for matrix evaluation fdo#49967 [Markus Mohrhard]

It should be #40967. I don't know where to place it but here?
Comment 7 Markus Mohrhard 2012-01-03 12:10:20 UTC
I know that but there is no way to correct that. I used the wrong bug number in the commit message and the release notes are automatically created.

It is not our only error in the release notes. From time to time we have a wrong bug number in our commit message and therefore in the release notes.
Comment 8 Reto 2012-01-03 12:35:56 UTC
Too bad but not cardinal, I admit ...
Comment 9 Reto 2012-01-17 13:46:46 UTC
I've testet it and all seems ok.