Issue 79571

Summary: link to range in external workbook containing reference does not evaluate
Product: Calc Reporter: dahn <oo>
Component: programmingAssignee: AOO issues mailing list <issues>
Status: CONFIRMED --- QA Contact:
Severity: Trivial    
Priority: P3 CC: issues, ooo, thomas.benisch
Version: OOo 1.0.0   
Target Milestone: ---   
Hardware: All   
OS: All   
Issue Type: ENHANCEMENT Latest Confirmation in: ---
Developer Difficulty: ---
Attachments:
Description Flags
source containing calculations for reference
none
target using calculations from source none

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.