[Libreoffice-bugs] [Bug 123863] New: Sumproduct delivers wrong result from calculated external data

[bugzilla-daemon at bugs.documentfoundation.org]

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 at lists.freedesktop.org
          Reporter: christoph at 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.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20190305/0565542c/attachment.html>