<html>
<head>
<base href="https://bugs.documentfoundation.org/">
</head>
<body><span class="vcard"><a class="email" href="mailto:suokunlong@126.com" title="Kevin Suo <suokunlong@126.com>"> <span class="fn">Kevin Suo</span></a>
</span> changed
<a class="bz_bug_link
bz_status_NEW "
title="NEW - Copying sheet to new document (or somewhere in same document) causes formula error if cells have relative reference to other sheets"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=85538">bug 85538</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;">Summary</td>
<td>Copying sheet to new document or before source sheet in same document causes #REF! error if cells have relative reference to other sheets
</td>
<td>Copying sheet to new document (or somewhere in same document) causes formula error if cells have relative reference to other sheets
</td>
</tr></table>
<p>
<div>
<b><a class="bz_bug_link
bz_status_NEW "
title="NEW - Copying sheet to new document (or somewhere in same document) causes formula error if cells have relative reference to other sheets"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=85538#c17">Comment # 17</a>
on <a class="bz_bug_link
bz_status_NEW "
title="NEW - Copying sheet to new document (or somewhere in same document) causes formula error if cells have relative reference to other sheets"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=85538">bug 85538</a>
from <span class="vcard"><a class="email" href="mailto:suokunlong@126.com" title="Kevin Suo <suokunlong@126.com>"> <span class="fn">Kevin Suo</span></a>
</span></b>
<pre>(In reply to Timur from <a href="show_bug.cgi?id=85538#c15">comment #15</a>)
#REF! error is just the result, the root cause is the treatment of sheet names
as relative reference.
It really does not matter where the source sheet is copied to: coping to the
beginning, or coping to a new file, they all resulted in the same formula
error, the root cause is because libreoffice is treating the cross reference as
relative reference.
All these duplicates should be either duplicates of <a class="bz_bug_link
bz_status_NEW "
title="NEW - Copying sheet to new document (or somewhere in same document) causes formula error if cells have relative reference to other sheets"
href="show_bug.cgi?id=85538">bug 85538</a>, or the new
enhancement request I have filed as <a class="bz_bug_link
bz_status_UNCONFIRMED "
title="UNCONFIRMED - Default to Use Absolute Reference to Sheet Name for Cell Reference to Another Sheet"
href="show_bug.cgi?id=107257">bug 107257</a>.</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>