[sc-issues] [Issue 104065] external link to variable , not cell

2009-08-06 Thread tab
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=104065
 Issue #|104065
 Summary|external link to variable, not cell
   Component|Spreadsheet
 Version|OOo 3.1
Platform|PC
 URL|
  OS/Version|Windows XP
  Status|UNCONFIRMED
   Status whiteboard|
Keywords|
  Resolution|
  Issue type|ENHANCEMENT
Priority|P3
Subcomponent|editing
 Assigned to|spreadsheet
 Reported by|tab





--- Additional comments from t...@openoffice.org Thu Aug  6 17:32:26 + 
2009 ---
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.

-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org



[sc-issues] [Issue 104065] external link to variable , not cell

2009-08-06 Thread tab
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=104065





--- Additional comments from t...@openoffice.org Thu Aug  6 17:34:21 + 
2009 ---
Created an attachment (id=63997)
File to link to


-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org



[sc-issues] [Issue 104065] external link to variable , not cell

2009-08-06 Thread tab
To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=104065





--- Additional comments from t...@openoffice.org Thu Aug  6 17:35:07 + 
2009 ---
Created an attachment (id=63998)
file with link


-
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification

-
To unsubscribe, e-mail: issues-unsubscr...@sc.openoffice.org
For additional commands, e-mail: issues-h...@sc.openoffice.org


-
To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org
For additional commands, e-mail: allbugs-h...@openoffice.org