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

            Bug ID: 155635
           Summary: A ODS sheet with links to another ODS file, copied in
                    another calc file loose links
           Product: LibreOffice
           Version: 7.5.3.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: Calc
          Assignee: [email protected]
          Reporter: [email protected]

Hi,

I prepared a ODS sheet with calculs that refers to another ODS file containing
standard numbers used a recall in the clacul sheet. The wish is to copy the
sheet with calculs to another project to not redo huge work and just adapt the
copy. The copy should keep reference to file with standard numbers to work
well.

Try this to redo bug :

1) Create a file ods TestA and type something in a cell at line x, save it.
2) Create a file ods TestB and select and copy full line of line x from file
TestA.
3) In file TestB, choose a line y of sheet w and right click + choose "past
special.../as a link"
All fine until here and link works well.
4) Create a new file TestC, copy the sheet w to File TestC (right click on
tab/copy/...) 
Result: in the copied sheet in file TestC, the supposed linked line x is filled
with {=}, loosing links to line x from TestA (looks like:
='file:///D:/testA.ods'#$Feuille1.$A5:$XFD5)

It is expected to see in TestC, copied sheet line y, the same link as in TestB
line y.

Regards,
Math

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to