Apache OpenOffice (AOO) Bugzilla – Issue 116833
Sheet linking malfunction after document saving
Last modified: 2017-05-20 10:30:45 UTC
When creating a new spreadsheet with two sheets and linking fields from one sheet into the other, the link reference isn't working any longer when the document is saved and the link reference is moved. Example: Sheet 2: Add in A2 the number 1 Sheet 1: Link to Sheet2 A2, e.g. =Sheet2.A2 Sheet 2: Add a new line before A2 to move the entry from A2 to A3 Sheet 1: Check if the link reference is updated to =Sheet2.A3 Save the document exit Open the document again Sheet 1: Check if the link reference is still OK (=Sheet2.A3) Sheet 2: Add a new line before A2 to move the entry from A3 to A4 Sheet 1: Check if the link reference is updated to =Sheet2.A4 Save the document and exit Open the document again Sheet 1: The Link reference is now broken and points to =Sheet2.A3 instead of =Sheet2.A4 This happens for new documents as well as for existing documents. Since we do rely on those links and on the version 3.2.0 do we need to have this fixed. If you have any questions or if you have trouble re-producing the issue, feel free to contact me anytime.
.
confirming
confirmed
Fixed in CWS "calc66".
cc-ing myself.
Is this fix going into version 3.4 or is the fix being back-ported to the old version too?
Reassigning to QA for verification.
Seen ok in cws calc66 -> verified