https://bugs.freedesktop.org/show_bug.cgi?id=75399
Priority: medium
Bug ID: 75399
Assignee: [email protected]
Summary: SUMPRODUCT function treat empty cells in different
ways (1 instead of 0), as the order of column vectors
are reversed
Severity: normal
Classification: Unclassified
OS: Windows (All)
Reporter: [email protected]
Hardware: x86-64 (AMD64)
Status: UNCONFIRMED
Version: 4.2.0.4 release
Component: Spreadsheet
Product: LibreOffice
Created attachment 94597
--> https://bugs.freedesktop.org/attachment.cgi?id=94597&action=edit
Asymetry in SUMPRODUCT
SUMPRODUCT function treat empty cells as 1 when the arrays in the calculations
in the argument are placed in reverse order, but treat empty cells as 0 when
the arrays in the calculations in the argument are placed in the usual
increasing order.
For example:
Increasing order: SUMPRODUCT($A3:$A11;H3:H11) treat empty cells as 0 in both
vectors
Reverse order: SUMPRODUCT(H3:H11;$A3:$A11) treat empty cells as 1 in
the H3:H11 vector but not in the $A3:$A11 vector
--
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
