<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 - Copying sheet forces Control "Linked cell" refs to be qualified by original sheet"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=126802">126802</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Copying sheet forces Control "Linked cell" refs to be qualified by original sheet
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.4.0.0.alpha0+ Master
</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>jim.avera@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
A checkbox control can have a "Linked cell" reference. The specified cell is
auto-updated to reflect the state of the checkbox. The reference may or may
not have a SHEETNAME. qualifier (e.g. SHEET1.C1 or just C1).
However, when the sheet is copied, un-qualified references are changed to be
qualified by the *original* sheet name. This defeats the intended behavior or
referring to the "current" sheet, i.e. all copies will update the same cell on
the original sheet.
The reference either should be left as-is (unqualified in this case), or if
some internal limitation requires adding a sheet qualifier, then the *new*
sheetname should be the qualifier (similar to what happens with Named Ranges
when copying sheets). But again, the most "obvious" behavior would be to not
change such references at all; if the user originally specified an unqualified
cell address, then it should remain that way, so it refers to the "current"
cell; and if the user does specify a sheet. qualifier, then that should be left
alone as well. IMO, of course...
Steps to Reproduce:
1. Open the attached "checkbox.ods". Do NOT enable macros.
2. Tools->Forms and CHECK "Design Mode"
4. Click on the checkbox Control to select it;
Rightclick->Control Properties...
Click the "Data" tab
5. Set "Linked Cell" to C1 (should already be set)
7. Copy the sheet
(rightclick on SHEET1 tab->Move or Copy, click Copy, then OK)
8. In the copied sheet, view "Linked cell" property of the checkbox
Control (see step 5 above)
Actual Results:
The Linked cell is changed from "C1" to "SHEET1.C1"
Expected Results:
The reference should remain unqualified (or, in the alternative, qualified with
the *new* sheetname)
Reproducible: Always
User Profile Reset: No
Additional Info:</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>