Apache OpenOffice (AOO) Bugzilla – Issue 104065
external link to variable, not cell
Last modified: 2013-12-22 14:17:28 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.
Created attachment 63997 [details] File to link to
Created attachment 63998 [details] file with link
Confirmed with AOO410m1(Build:9750) - Rev. 1551264 2013-12-17_04:10:52 - Rev. 1551455 Debian