Bug 75425

Summary:	Libreoffice Calc's function SUMPRODUCT returns incorrect value when blank cells used for Array1
Product:	LibreOffice	Reporter:	TJ <Herring.Choker>
Component:	Calc	Assignee:	Not Assigned <libreoffice-bugs>
Status:	RESOLVED DUPLICATE
Severity:	normal	CC:	Herring.Choker
Priority:	medium
Version:	unspecified
Hardware:	x86-64 (AMD64)
OS:	Windows (All)
Whiteboard:
Crash report or crash signature:		Regression By:

Description TJ 2014-02-24 09:05:00 UTC

SUMPRODUCT treats blank cells as containing "1" rather than "0" - only in first argument: New in 4.2.0.4

Comment 1 Jacques Guilleron 2014-02-24 11:34:13 UTC

Hello TJ,

Thanks for reporting that.
This was previously reported in Bug 74479 - CALC problem counting weekdays with sumproduct. Only Saturdays are not counted correctly when the selection contains empty cells or no date. SUMPRODUCT() result error with functions or calculations the last parameter.
This is already fixed and patch is available in LO 4.2.1.

Kind regards,

Jacques

*** This bug has been marked as a duplicate of bug 74479 ***