[Libreoffice-bugs] [Bug 123863] broken 'link to external data' | was: 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
----------------------------------------------------------------------------
         Resolution|---                         |NOTABUG
             Status|NEW                         |RESOLVED
            Summary|Sumproduct delivers wrong   |broken 'link to external
                   |result from calculated      |data' | was: Sumproduct
                   |external data               |delivers wrong result from
                   |                            |calculated external data

--- Comment #10 from b. <newbie-02 at gmx.de> ---
sorry, typo in prev. comment, 

not 'StücklisteImportData' has #REF! error, but 'StuecklisteImportData' with
'ue', 

rechecked, starting with files provided by OP: 

check / set language settings locale: german, 
open file 'BUG SumProduct.ods', 
check edit - Links to External Files: no 'Element:' assigned in footer area, 
break link, 
open file 'BUG External Data.ods', 
check ctrl-F3 - Manage Names: StuecklisteImportData has #REF! error, delete it, 
open sheet Stückliste, select all (ctrl-a), type StuecklisteImportData in 'name
box', 
check ctrl-F3 - Manage Names: StuecklisteImportData now $SStückliste.$A:$AMJ, 
save file, 
change to 'BUG SumProduct.ods', 
select tab 'Stückliste', select all (ctrl-a), 
sheet - Link to External Data: browse to data file, open, 
select 'StuecklisteImportData' from Available Tables/Ranges, 
change to sheet 'Übersicht', 
check C1: 8, 

thus calc, 'sumproduct' and calculation correct, link was broken, 

setting 'NOTABUG'

-- 
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/20200509/9db327cb/attachment-0001.htm>