To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=76741 Issue #|76741 Summary|referencing a cell from another document Component|Spreadsheet Version|OOo 2.2 Platform|All URL| OS/Version|Mac OS X Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|code Assigned to|spreadsheet Reported by|padmavyuha
------- Additional comments from [EMAIL PROTECTED] Fri Apr 27 05:55:01 +0000 2007 ------- Either a bug or 2 very related bugs here, behaviour tested in OOo X11 2.1, 2.1 , and winxx 2.2: 1) Create 2 spreadsheet docs test1 & test2, enter values and save each. 2) Creat a cell reference link in test1 with the source cell in test2. Save both docs again. 3) Update the contents of the source cell in test2 and save test2. There's no way to update the contents of the target (linked) cell in test1, short of deleting the formula and re-establishing the link again (and sometimes the new cell link will still show the OLD value from test2 as its new value). F9 and Tools-Cell Contents-Recalculate do nothing. On closing both docs and re-opening them, opening test1 brings up an alert giving you the option to update cell references from other docs, but it doesn't actually update the value. (Incidentally, this alert comes up even after you delete the cross-doc cell reference - presumably if the reference is saved in edit history or something - so it offers to update cell references that are no longer in the current spreadsheet!) The side-issue possible 2nd bug here is that sometimes if in (1) you then edit the values in test2 and re-save the doc, on performing (2) you get the old pre-edit cell value from test2 instead of the current value when you first set up the reference 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: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]