<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:newbie-02@gmx.de" title="b. <newbie-02@gmx.de>"> <span class="fn">b.</span></a>
</span> changed
<a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - broken 'link to external data' | was: Sumproduct delivers wrong result from calculated external data"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=123863">bug 123863</a>
<br>
<table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>What</th>
<th>Removed</th>
<th>Added</th>
</tr>
<tr>
<td style="text-align:right;">Resolution</td>
<td>---
</td>
<td>NOTABUG
</td>
</tr>
<tr>
<td style="text-align:right;">Status</td>
<td>NEW
</td>
<td>RESOLVED
</td>
</tr>
<tr>
<td style="text-align:right;">Summary</td>
<td>Sumproduct delivers wrong result from calculated external data
</td>
<td>broken 'link to external data' | was: Sumproduct delivers wrong result from calculated external data
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - broken 'link to external data' | was: Sumproduct delivers wrong result from calculated external data"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=123863#c10">Comment # 10</a>
on <a class="bz_bug_link
bz_status_RESOLVED bz_closed"
title="RESOLVED NOTABUG - broken 'link to external data' | was: Sumproduct delivers wrong result from calculated external data"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=123863">bug 123863</a>
from <span class="vcard"><a class="email" href="mailto:newbie-02@gmx.de" title="b. <newbie-02@gmx.de>"> <span class="fn">b.</span></a>
</span></b>
<pre>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'</pre>
</div>
</p>
<hr>
<span>You are receiving this mail because:</span>
<ul>
<li>You are the assignee for the bug.</li>
</ul>
</body>
</html>