<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, copying of cell to another sheet creates name reference not in dropdown, and not 'undone' with undo of copy,"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=130371">130371</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>calc: editing: ui: weakness with named ranges, copying of cell to another sheet creates name reference not in dropdown, and not 'undone' with undo of copy,
</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. 2:
copying of sheet2.A3:B3 creates a name reference 'value' to $sheet4.$B$2, with
the 'scope' sheet4, that is – sometimes – not shown in the name reference
select box below the font type box, but on 'editing named ranges' by ctrl-F3,
no. 2a:
this name reference is not 'undone' with ctrl-Z if you undo the step which
produced it.
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 comments above
Actual Results:
name reference 'value' on sheet4 not shown in 'name-select-dropdown-box', name
reference 'value' on sheet4 not reverted by undo,
Expected Results:
name reference 'value' on sheet4 should be shown in 'name-select-dropdown-box',
name reference 'value' on sheet4 should be deleted on undo of the step which
produced it,
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>