Bug 93049 - Regression: Sumproduct function does not work correctly in Calc
Summary: Regression: Sumproduct function does not work correctly in Calc
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.4.5.2 release
Hardware: Other All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2015-07-31 11:20 UTC by grofaty
Modified: 2015-07-31 12:21 UTC (History)
0 users

See Also:
Crash report or crash signature:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description grofaty 2015-07-31 11:20:22 UTC 
Hi,
today I installed LibreOffice 4.4.5.2 on Windows 7.

1. Start LibreOffice Calc.
2. In cells A1, A2, A3, B1, B2, B3 type in value 10.
3. In cell A4 type in formula: =SUM(A1:B3) and the result is corretly 60.
4. In cell A5 type in formula: =SUMPRODUCT(A1:B3) and the result is again 60 which is wrong. Result of sumprodcut should be "sum of the product", so: (10 * 10) + (10 * 10) + (10 * 10) = 300

I know this was working fine, so this is a regression problem.
Regards
Comment 1 grofaty 2015-07-31 11:26:31 UTC 
Hi,
now I have checked the release notes of LibreOffice 4.4.5.2 https://wiki.documentfoundation.org/Releases/4.4.5/RC2 and there is bug tdf#91453 listed https://bugs.documentfoundation.org/show_bug.cgi?id=91453 that is related to sumproduct function. In there it is stated (at the end) that fix was commited in 4.4.5 brench. Don't know if this commit caused my reported problem or not. But I am sure sumproduct function used to work in LibreOffice Calc.

Don't know if this is the same bug. Bug reproduce scenario is not the same as mine.
Regards
Comment 2 Tomaz Vajngerl 2015-07-31 11:43:47 UTC 
That's not how SUMPRODUCT works. SUMPRODUCT takes arrays as input - so it multiplies each value of the array, then sums the results. 

So the correct usage is SUMPRODUCT(A1:A3;B1:B3).
Comment 3 grofaty 2015-07-31 12:21:13 UTC 
Tomaz, that is right. I see I have confused SUMPRODUCT (which uses arrays) with SUMIF (which uses range).

Sorry for false report.