https://bugs.documentfoundation.org/show_bug.cgi?id=123863
b. <[email protected]> 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. <[email protected]> ---
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._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
