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!
Created attachment 51291 [details]
Calc-file with an example proving evidence of the bug
LO 3.4.3 OOO340m1 (Build:302)
Ubuntu 10.04.3 x86
Linux 2.6.32-33-generic Russian UI
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.
I'm taking a look at it.
pushed a fix to master and send a patch for 3-4 to the ML
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?
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.
Too bad but not cardinal, I admit ...
I've testet it and all seems ok.