<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><table border="1" cellspacing="0" cellpadding="8">
<tr>
<th>Bug ID</th>
<td><a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - : Link to external .ods file returns incorrect data"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=131100">131100</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>: Link to external .ods file returns incorrect data
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.2.5.2 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>Windows (All)
</td>
</tr>
<tr>
<th>Status</th>
<td>UNCONFIRMED
</td>
</tr>
<tr>
<th>Severity</th>
<td>normal
</td>
</tr>
<tr>
<th>Priority</th>
<td>medium
</td>
</tr>
<tr>
<th>Component</th>
<td>Calc
</td>
</tr>
<tr>
<th>Assignee</th>
<td>libreoffice-bugs@lists.freedesktop.org
</td>
</tr>
<tr>
<th>Reporter</th>
<td>g_e_fox@hotmail.com
</td>
</tr></table>
<p>
<div>
<pre>Created <span class=""><a href="http://bugs.documentfoundation.org/attachment.cgi?id=158347" name="attach_158347" title="zip file containing 7 calc worksheets illustrating link problem">attachment 158347</a> <a href="http://bugs.documentfoundation.org/attachment.cgi?id=158347&action=edit" title="zip file containing 7 calc worksheets illustrating link problem">[details]</a></span>
zip file containing 7 calc worksheets illustrating link problem
I have a group of spreadsheets, one for each "month", where the value of a cell
in a given month is intended to be set equal to a value in the previous month,
but the link sometimes returns an incorrect value. The attached zip file
contains 7 such spreadsheets to illustrate the problem.
In the attachment, the September sheet is not linked to any other sheet, and
successive months sheets are linked to the previous month. There are sheets
attached for September though March.
Note that the link for the October through February sheets returns the correct
values from the previous month's spreadsheet but that for March returns 0 when
the correct value is 160. The problem cannot be corrected by "updating" the
link.
This problem has proven very difficult to replicate and sometimes disappears
(or appears) if the associated files are moved to a different directory.</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>