[Libreoffice-bugs] [Bug 131633] New: Referencing formula cannot be copied to a new ods file

[bugzilla-daemon at bugs.documentfoundation.org]

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

            Bug ID: 131633
           Summary: Referencing formula cannot be copied to a new ods file
           Product: LibreOffice
           Version: 6.4.2.2 release
          Hardware: x86-64 (AMD64)
                OS: Linux (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: libreoffice-bugs at lists.freedesktop.org
          Reporter: omui+libreoffice at pm.me

Description:
On Linux, when I tried to copy formula that reference a cell on an external,
local ods file to a new ods file, the formula will be lost.




Steps to Reproduce:
1. Create 3 ods files: 1.ods, 2.ods and 3.ods

2. On 1.ods, enter A1=1, A2=2

3. On 2.ods, reference values from 1.ods, such that:

A1 of 2.ods = A1 from 1.ods
A2 of 2.ods = A2 from 1.ods

Such that:
A1='file:///local.directory/1.ods'#$Sheet1.A1
A2='file:///local.directory/1.ods'#$Sheet1.A2

, where "file:///local.directory/1.ods" is the location of 1.ods


4. Try copying A1 and A2 from 2.ods to 3.ods, either with Ctrl+C and V or from
the menu.

Actual Results:
On 3.ods, each copied cell will have a "#NAME?" error, and each cell only has
"=" inside. 


Expected Results:
On 3.ods, the referencing formula are copied over, where

A1='file:///local.directory/1.ods'#$Sheet1.A1
A2='file:///local.directory/1.ods'#$Sheet1.A2




Reproducible: Always


User Profile Reset: Yes



Additional Info:
It appears that the external link (to 1.ods) is not copied over.

During paste, if I select "Paste Special" and check "Link", then an array will
be copied. However, with arrays, each cell cannot be individually modified.

-- 
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/20200327/9c31d4fb/attachment-0001.htm>