[Libreoffice-bugs] [Bug 116413] New: Calc: Using Paste Special > Options > Link, but the target cell doesn't change when source is updated

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=116413

            Bug ID: 116413
           Summary: Calc: Using Paste Special > Options > Link, but the
                    target cell doesn't change when source is updated
           Product: LibreOffice
           Version: 6.0.2.1 release
          Hardware: Other
                OS: Mac OS X (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: kam3don at gmail.com

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

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180315/93f54e4e/attachment.html>