https://bugs.documentfoundation.org/show_bug.cgi?id=101916
Bug ID: 101916
Summary: SUMPRODUCT bug
Product: LibreOffice
Version: unspecified
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Converting OpenOffice Calc spreadsheet to LO, SUMPRODUCT function in LO has
what I consider to be a bug. If one of the multiplication terms is a simple
range, SUMPRODUCT throws a #VALUE error if a cell with text is encountered
within the range, instead of the cell's value defaulting to zero. Have to
resort to using ISNUMBER() function as a workaround (which is a pain), e.g. --
= SUMPRODUCT((expr1)*(expr2)*(C$1:C30))
fails if a cell within C1:C30 has text
= SUMPRODUCT((expr1)*(expr2)* (IF(ISNUMBER(C$1:C30), C$1:C30, 0)))
works okay
-m.
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
