https://bugs.documentfoundation.org/show_bug.cgi?id=133536
--- Comment #17 from Arundel <gauthiera...@hotmail.com> --- I have a very similar problem, but with the linking of cells from a main sheet to cells in an embedded OLE sheet. I use the terms "source cell" as the source cell in the main sheet, and "destination cell" as the destination cell in the embedded OLE sheet. I used two methods to set up the link: the GUI, and the Paste Special > Link. 1) With the GUI method, I enter the equals sign in the inputbar for the destination cell, then select a source from the main sheet with some text, and press enter. Some file URL syntax is generated in the inputbar. 2) With Paste Special method, I select the source cell in the main sheet, copy, then Paste Special > Link for the destination cell. Some file URL syntax is generated in the inputbar. On freshly inserted OLE's with only one destination cell set up with method 1: 1) the destination cell's value is correct. 2) Edit > Links to external files... > Update can update the destination cell's value indefinitely. After a reload: I encounter different destination values, all conveying the same outcome (the links not working); when I redirect the link to another source cell through method 1 or 2, the destination cell's value becomes 0; and when I press Edit > Links to external files... > Update, no update happens to the destination cell's value. I even witnessed after I linked, the destination cell's value becoming an old version of the source cell's. But I haven't had the time to find the reproduction steps for this. Also, as my understanding of what is supposed to happen when entering the OLE edit mode comes from OpenOffice, there is a major step missing that I never witness in LibreOffice: the prompt for updating the links. OpenOffice always shows such prompt. So even if there would not be the mentioned bug, the prompt missing is also very annoying as you would need to manually update them. My GUI is in Dutch so I have translated some terms. Both OpenOffice and LibreOffice have this problem, and it seems to me that you need very similar steps to reproduce the bug in both. I used OpenOffice v4.1.15 and LibreOffice v7.6.5.2. The main sheet has been saved, with both programs at these versions. Version: 7.6.5.2 (X86_64) / LibreOffice Community Build ID: 38d5f62f85355c192ef5f1dd47c5c0c0c6d6598b CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win Locale: nl-NL (nl_NL); UI: nl-NL Calc: threaded This bug is critical as embedded modularity is non-existent for my sheets. I was so happy to break free from the main grid by embedding another grid (OLE), but then I discovered this.. Please fix it! OP, does your bug still occur? Who can reproduce mine? -- You are receiving this mail because: You are the assignee for the bug.
