[Libreoffice-bugs] [Bug 143225] External references to cells in other files disappear when copying sheet to another workbook, even when directly importing the relevant sheet into the other workbook.

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #5 from Nenad Antic <libreoffice at famantic.net> ---
I now uploaded sample worksheets to demonstrate the bug.

To reproduce:

1. Open the 'importer.q.ods' and make sure it is showing data from the file
'Export_GCal_to_GSheet.202106.redacted.ods'.

2. Open 'Tidsredovisning 2021.Camilla Norén.ods'. This is where I want a copy
of the importer sheet.

3. In 'importer.q.ods', right click the sheet tab and choose 'Move or Copy
Sheet... '. In the dialog choose to copy the sheet to the other document
'Tidsredovisning 2021.Camilla Norén.ods'. 

4. In 'Tidsredovisning 2021.Camilla Norén.ods' look at the formulas in columns
A, B, C and S (as well as G, I, K and M). The reference to workbook
'Export_GCal_to_GSheet.202106.redacted.ods' is gone everywhere.

-- 
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/20210707/d7b6a763/attachment.htm>