Apache OpenOffice (AOO) Bugzilla – Full Text Issue Listing
|Summary:||link to range in external workbook containing reference does not evaluate|
|Component:||programming||Assignee:||AOO issues mailing list <issues>|
|Status:||CONFIRMED ---||QA Contact:|
|Priority:||P3||CC:||issues, ooo, thomas.benisch|
|Issue Type:||ENHANCEMENT||Latest Confirmation in:||---|
Description dahn 2007-07-13 09:38:58 UTC
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.
Comment 1 dahn 2007-07-13 09:42:44 UTC
Created attachment 46742 [details] source containing calculations for reference
Comment 2 dahn 2007-07-13 09:43:39 UTC
Created attachment 46744 [details] target using calculations from source
Comment 3 frank 2007-09-03 15:53:30 UTC
Hi Frank, what do you think about this? Currently we link the formulas into the target file, Excel the numbers. Should we change it ? Frank
Comment 4 ooo 2007-09-04 12:03:34 UTC
I simply consider the current behavior a bug. Importing the formulas doesn't make sense at all as soon as the formulas reference cells not within the imported range. I doubt that people used this "feature" to create "sophisticated template ranges" or such.