Issue 79571 - link to range in external workbook containing reference does not evaluate
Summary: link to range in external workbook containing reference does not evaluate
Status: CONFIRMED
Alias: None
Product: Calc
Classification: Application
Component: programming (show other issues)
Version: OOo 1.0.0
Hardware: All All
: P3 Trivial with 2 votes (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
URL:
Keywords:
Depends on:
Blocks:
 
Reported: 2007-07-13 09:38 UTC by dahn
Modified: 2013-08-07 15:12 UTC (History)
3 users (show)

See Also:
Issue Type: ENHANCEMENT
Latest Confirmation in: ---
Developer Difficulty: ---


Attachments
source containing calculations for reference (14.90 KB, application/vnd.oasis.opendocument.spreadsheet)
2007-07-13 09:42 UTC, dahn
no flags Details
target using calculations from source (15.78 KB, application/vnd.oasis.opendocument.spreadsheet)
2007-07-13 09:43 UTC, dahn
no flags Details

Note You need to log in before you can comment on or make changes to this issue.
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.