<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 - calc: editing: ui: weakness with named ranges, move of cell to another sheet destroys referencing to local name reference there"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=130370">130370</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>calc: editing: ui: weakness with named ranges, move of cell to another sheet destroys referencing to local name reference there
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>unspecified
</td>
</tr>
<tr>
<th>Hardware</th>
<td>All
</td>
</tr>
<tr>
<th>OS</th>
<td>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>newbie-02@gmx.de
</td>
</tr></table>
<p>
<div>
<pre>Description:
@Xisco: sorry, i was asked bei Eike to open a new bug, pls. do not! close as
dup of #81330.
the sheet attached to #81330:
<a href="https://bugs.documentfoundation.org/attachment.cgi?id=102780">https://bugs.documentfoundation.org/attachment.cgi?id=102780</a>
shows more weaknesses, no. 1:
in the attachement the move of sheet2.B1 to sheet3.B1 destroys the referencing
to 'value' (which points to sheet3.B2) in cell sheet3.B3, after the move of B1
sheet3.B3 shows =#NAME? with ver. 6.4.03. unpar. and ver. 7.0.0.0.alpha1+
retyping '=value' in sheet3.B3 helps out, hard recalc doesn't
additional amendments:
in the comments at #81330 and in the procedure described in the sheet are some
errors? the description given into the attachement suggests copying of B2, imho
it was intendedto refer to B1, it's advised to 'copy' B2, imho it was intended
to move B1?
if above problems are covered elsewhere feel free to ad a comment pointing
there and close this bug,
reg.
b.
Steps to Reproduce:
see referenced sheet and comments above
Actual Results:
cell sheet3.B3 switching to =#NAME? on move of sheet2.B1 to sheet3.B1
Expected Results:
cell sheet3.B3 holding it-äs reference to 'value' (cell sheet3.B2)
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 6.4.0.3 (x64)
Build ID: b0a288ab3d2d4774cb44b62f04d5d28733ac6df8
CPU threads: 8; OS: Windows 6.1 Service Pack 1 Build 7601; UI render: default;
VCL: win;
Locale: de-DE (de_DE); UI-Language: en-US
Calc:</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>