Bug 70784 - PRODUCT() in array formula with operators in argument ignores first non-empty cell in range
Summary: PRODUCT() in array formula with operators in argument ignores first non-empty...
Status: RESOLVED DUPLICATE of bug 76663
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
4.1.3.1 rc
Hardware: Other All
: medium major
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2013-10-23 00:52 UTC by ariel cornejo
Modified: 2014-04-25 23:49 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Attachments
Example (13.48 KB, application/vnd.oasis.opendocument.spreadsheet)
2013-10-23 00:52 UTC, ariel cornejo 		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 ariel cornejo 2013-10-23 00:52:26 UTC 
Created attachment 88019 [details]
Example

An array formula with an expression inside PRODUCT(), such as =PRODUCT(range+123), will ignore the top non-empty cell of the leftmost column.

Looking at the attached example, all {=PRODUCT(range+0)} formulas yield a wrong value, because the bolded '4' is left out, and changing it has no effect. However, if it is deleted then it's the '3' that will be left out of the calculation (A14 in the 2-D example).

This *may* have some relationship to bug #40732, where using both ROW() and COLUMN() in an array formula fails for the top left corner.
Comment 1 colin.ruthven 2014-03-14 12:21:18 UTC 
I have experienced this bug with Version: 4.2.1.1, Build ID: 4.2.1.1-1.fc20 (64 bit).

This renders Calc useless for a lot of financial applications as it silently returns incorrect results. A common use is in calculating compounded returns - when the first value is ignored you can make bad decisions.
Comment 2 Kohei Yoshida 2014-04-25 23:49:36 UTC 
I just fixed this for both 4.2 and 4.1.

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