Bug 98174 - incorrect value in SUMPRODUCT formula
Summary: incorrect value in SUMPRODUCT formula
Status: CLOSED INSUFFICIENTDATA
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
5.0.5.2 release
Hardware: All All
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2016-02-25 10:17 UTC by Jiri Horacek
Modified: 2016-09-03 08:59 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
incorrect value in SUMPRODUCT formula (43.30 KB, application/vnd.oasis.opendocument.spreadsheet)
2016-02-25 10:17 UTC, Jiri Horacek 		Details
Screenshot of calc, where is shon cell with formula, and bad values. (181.25 KB, image/png)
2016-02-25 10:42 UTC, Jiri Horacek 		Details
View All 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 Jiri Horacek 2016-02-25 10:17:26 UTC 
Created attachment 122981 [details]
incorrect value in SUMPRODUCT formula

SUMPRODUCT
Values in column B evaluate incorrect.
Some cells has value only as part of its formula, SUMPRODUCT part is ignored, and some has any big big number.
Comment 1 Jiri Horacek 2016-02-25 10:42:56 UTC 
Created attachment 122982 [details]
Screenshot of calc, where is shon cell with formula, and bad values.
Comment 2 GerardF 2016-02-25 14:02:40 UTC 
Works fine and gives correct result for me with 5.0.5.2.

Did you have Open CL enabled?