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

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=123863

b. <newbie-02 at gmx.de> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
                 CC|                            |newbie-02 at gmx.de

--- Comment #7 from b. <newbie-02 at gmx.de> ---
Created attachment 156802
  --> https://bugs.documentfoundation.org/attachment.cgi?id=156802&action=edit
external_data for working sample

i've build you a sample that shows (observe red bordered cell on sheet1): 

(data file here, calcsheet in next comment,) 

'linking in' external data can work even with: 
• Data is from an external table
• Data in that table is calculated
• Data is refreshed manually or automatically

try to find the difference towards your sheet, did you pull in the data in
ranges? (i took the full sheet), did you pull in the data as html? (i tried as
copy and as link), as such conditions are hard to analyse or reverse, i'd like
if you can provide a step by step script to produce a failing version with
small amounts of data ... 

i could not! repro your suggestion that after replacing the external data by
copied text (of itself) the formula would work, neither that it'll work by
replacing C1 with a text copy of itself ... :-(

-- 
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/20191228/9dcaf75b/attachment-0001.htm>