Issue 104065 - external link to variable, not cell
Summary: external link to variable, not cell
Alias: None
Product: Calc
Classification: Application
Component: editing (show other issues)
Version: OOo 3.1
Hardware: PC All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2009-08-06 18:32 UTC by tab
Modified: 2013-12-22 14:17 UTC (History)
2 users (show)

See Also:
Latest Confirmation in: 4.1.0-dev
Developer Difficulty: ---

File to link to (6.98 KB, text/plain)
2009-08-06 18:34 UTC, tab
no flags Details
file with link (7.33 KB, text/plain)
2009-08-06 18:35 UTC, tab
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
Description tab 2009-08-06 18:32:26 UTC
1: Read LnkX.ods: xx=B1=3,  and zz=B2=4*B1=12;
2: Read LnkY.ods: aa=C2='file:///C:/Docu.../LnkX.ods'#$Sheet1.B1; result: 3. OK.
3: insert a row before row 1 in LnkX.ods; now, B1 is blank, and B2=3. Save file.
4: close and reopen LnkY.ods; OO asks: 'update links?'. Click yes. Now, aa=0
because, in LnkX.ods,  B1=0, because the reference (in aa=) to cell B1 has not
been updated to point to B2. OK; it would be difficult for a formula in LnkY to
keep track of changes in another file like LnkX. (In LnkX, zz is still 12
because Calc was smart enough, in the same SS, to change the formula from
'=4*B1'  to  '=4*B2'.)
 A solution to the above problem would be to assign a variable name such as 'Xa'
to cell B1 in LnkX, and to use that name in the aa formula, instead of the cell
name B1. Possible formula: aa='file:///C:/Docu.../LnkX.ods'#Xa; Then, Calc would
keep track of Xa (eg, when a row in inserted before), and the aa formula would
still give the right result.
Comment 1 tab 2009-08-06 18:34:21 UTC
Created attachment 63997 [details]
File to link to
Comment 2 tab 2009-08-06 18:35:07 UTC
Created attachment 63998 [details]
file with link
Comment 3 Edwin Sharp 2013-12-22 14:17:28 UTC
Confirmed with
AOO410m1(Build:9750)  -  Rev. 1551264
2013-12-17_04:10:52 - Rev. 1551455