https://bugs.freedesktop.org/show_bug.cgi?id=75399
Priority: medium Bug ID: 75399 Assignee: libreoffice-bugs@lists.freedesktop.org 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: laszlov...@gmail.com 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 Libreoffice-bugs@lists.freedesktop.org http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs