Created attachment 93614 [details]
Empty Cells in =SUMPRODUCT-formula-Arrays are evaluated as 1, if the corresponding Cell is *not* empty.
I expect that they are evaluated as 0 as in prior Version of LO up to 4.1
On pc Debian x86-64 with master sources updated today, I can reproduce this.
Kohei/Markus/Eike: one for you?
Hi karolus, Julien,
I reproduce too with LO 22.214.171.124 and LO 126.96.36.199.0+
Build ID: 7a7ef5a915f7e4f4a9a21b819ab1013d6333a8d8
TinderBox: Win-x86@42, Branch:libreoffice-4-2, Time: 2014-01-28_05:46:06
In this case we have an option to set to True:
In Tools > Options > LibreOffice Calc > Formula > Custom > Details :
Treat empty string as zero.
This leave confuse this case where a empty cell is always treated as 1, but understood by any user as 0.
Sorry for the message in two parts,
*** This bug has been marked as a duplicate of bug 74479 ***