https://bugs.freedesktop.org/show_bug.cgi?id=70784
Priority: medium
Bug ID: 70784
Assignee: [email protected]
Summary: PRODUCT() in array formula with operators in argument
ignores first non-empty cell in range
Severity: major
Classification: Unclassified
OS: All
Reporter: [email protected]
Hardware: Other
Status: NEW
Version: 4.1.3.1 rc
Component: Spreadsheet
Product: LibreOffice
Created attachment 88019
--> https://bugs.freedesktop.org/attachment.cgi?id=88019&action=edit
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.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
