<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: Using Paste Special > Options > Link, but the target cell doesn't change when source is updated"
href="https://bugs.documentfoundation.org/show_bug.cgi?id=116413">116413</a>
</td>
</tr>
<tr>
<th>Summary</th>
<td>Calc: Using Paste Special > Options > Link, but the target cell doesn't change when source is updated
</td>
</tr>
<tr>
<th>Product</th>
<td>LibreOffice
</td>
</tr>
<tr>
<th>Version</th>
<td>6.0.2.1 release
</td>
</tr>
<tr>
<th>Hardware</th>
<td>Other
</td>
</tr>
<tr>
<th>OS</th>
<td>Mac OS X (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>kam3don@gmail.com
</td>
</tr></table>
<p>
<div>
<pre>Description:
In D23 I type the number "2". In E23 I also type the number "2".
I copy D23, select E23 and Paste Special > Paste All
+ Operations: Add
+ Options: Link.
+ Shift Cells: Don't shift
The number "4" now appears in E23, and the cell reference says
=2+($SpreadsheetName.$D$23).
Looks great.
I change the value in D23 to 3, hit Enter, hit Save, but E23 remains the same.
Steps to Reproduce:
1.Enter a number in a cell.
2.Enter another number in a different cell.
3.Copy the value in the first cell, then select the second cell to paste into.
4.Chose Paste Special > Paste All + Operations Add + Options > Link.
5. Then update the value in the first cell. Hit Enter, hit Save.
Actual Results:
Instead of updating to the new value as shown in the cell reference formula,
the second cell stays at the same value.
Expected Results:
The second cell should have updated its value to reflect the changed value of
the first cell, to which it is linked.
Reproducible: Always
User Profile Reset: Yes
OpenGL enabled: Yes
Additional Info:
>From the LibreOffice Help Files (Paste Special)
Inserts the contents of the clipboard into the current file in a format that
you can specify.
Choose Edit - Paste Special
Operations
Select the operation to apply when you paste cells into your sheet.
Add
Adds the values in the clipboard cells to the values in the target cells. Also,
if the clipboard only contains comments, adds the comments to the target cells.
Options
Sets the paste options for the clipboard contents.
Link
Inserts the cell range as a link, so that changes made to the cells in the
source file are updated in the target file. To ensure that changes made to
empty cells in the source file are updated in the target file, ensure that the
Insert All option is also selected.
You can also link sheets within the same spreadsheet. When you link to other
files, a DDE link is automatically created. A DDE link is inserted as a matrix
formula and can only be modified as a whole.
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10_13_3) AppleWebKit/537.36
(KHTML, like Gecko) Chrome/64.0.3282.186 Safari/537.36</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>