Issue 116833 - Sheet linking malfunction after document saving
Summary: Sheet linking malfunction after document saving
Status: CLOSED FIXED
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.2
Hardware: All Windows 7
: P3 Trivial (vote)
Target Milestone: 3.4.0
Assignee: kla
QA Contact: issues@sc
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2011-02-06 11:20 UTC by sreber
Modified: 2017-05-20 10:30 UTC (History)
4 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments

Note You need to log in before you can comment on or make changes to this issue.
Description sreber 2011-02-06 11:20:30 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.
Comment 1 Oliver Brinzing 2011-02-07 08:18:21 UTC
.
Comment 2 Oliver Brinzing 2011-02-07 08:31:53 UTC
confirming
Comment 3 niklas.nebel 2011-02-08 09:27:50 UTC
confirmed
Comment 4 niklas.nebel 2011-02-28 11:36:41 UTC
Fixed in CWS "calc66".
Comment 5 kai.sommerfeld 2011-03-04 09:00:10 UTC
cc-ing myself.
Comment 6 sreber 2011-03-08 14:13:18 UTC
Is this fix going into version 3.4 or is the fix being back-ported to the old version too?
Comment 7 niklas.nebel 2011-03-15 13:47:00 UTC
Reassigning to QA for verification.
Comment 8 kla 2011-03-18 12:23:34 UTC
Seen ok in cws calc66 -> verified