To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=79571 Issue #|79571 Summary|link to range in external workbook containing referenc |e does not evaluate Component|Spreadsheet Version|1.0.0 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P3 Subcomponent|programming Assigned to|spreadsheet Reported by|dahn
------- Additional comments from [EMAIL PROTECTED] Fri Jul 13 08:38:58 +0000 2007 ------- When referencing the results of someones calculations from another workbook-and-sheet, the result is a local reference; To reproduce: - make a new workbook - on sheet1 enter values a1 = <1> and a2 = <2> - on sheet2 enter values a1 = <=sheet1.a1 + 10> and a2 = <=sheet1.a2 + 10> - on sheet2 select the range a1:a2 - from the menu select Data|Define Range... - enter the name (i.e. 'pubformulas') - save the workbook as 'source.ods' - make a new workbook - while positioned at sheet1.a1; select Insert|Link to External Data... - select the first workbook and range Now 'Err:522' is printed in both fields sheet1.a1 and sheet1.a2 in the target workbook. Would the latter selection be made on sheet2 and values be entered on sheet1 the reference would be resolved, but locally. --------------------------------------------------------------------- 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]