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
Repro. Already in oldest of Windows 4.3 bibisect repo. Version: 24.2.0.0.alpha0+ (X86_64) / LibreOffice Community Build ID: 218a7650a5cf03f895bed19c68d6f02daec536e9 CPU threads: 2; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win Locale: en-US (en_FI); UI: en-US Calc: threaded