https://bugs.documentfoundation.org/show_bug.cgi?id=123863
Bug ID: 123863
Summary: Sumproduct delivers wrong result from calculated
external data
Product: LibreOffice
Version: 6.2.0.3 release
Hardware: All
OS: Mac OS X (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: christ...@vogelbuschnet.de
Created attachment 149735
--> https://bugs.documentfoundation.org/attachment.cgi?id=149735&action=edit
The attached to files are "BUG SUMPRODUCT" (open this and have the link updated
automatically or manually) and "BUG External Data".
Summary:
The attached example shows that under the given conditions SUMPRODUCT fails:
• Data is from an external table
• Data in that table is calculated
• Data is refreshed manually or automatically
Setup:
The attached tables are one data table that feeds content to our test table.
I use SUMPRODUCT which claims a certain word is found zero times. Below I do
the same comparison but with IF and it works and the SUM over the IF also
works.
What you see:
C1 is (after updating the table) 0 but should be like C2 8
Conditions to narrow the problem down:
The following changes make SUMPRODUCT work correctly:
• If the linked data is replaced by the same context but as text instead of
formula
• !!! Running SUMPRODUCT manually after the connections have been updated (copy
the Formula from C1 into C1 and the result is correct again) !!!
I hope with all of this the bug is trivial to find!
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs