Issue 108469 - Link to External Data inserts formula not data
Summary: Link to External Data inserts formula not data
Alias: None
Product: Calc
Classification: Application
Component: open-import (show other issues)
Version: OOo 3.0.1
Hardware: Mac All
: P3 Trivial (vote)
Target Milestone: ---
Assignee: AOO issues mailing list
QA Contact:
Depends on:
Reported: 2010-01-19 19:47 UTC by asmilwho
Modified: 2013-03-08 12:34 UTC (History)
2 users (show)

See Also:
Issue Type: DEFECT
Latest Confirmation in: 3.4.1
Developer Difficulty: ---


Note You need to log in before you can comment on or make changes to this issue.
Description asmilwho 2010-01-19 19:47:17 UTC
Spreadsheet 1 contains a cell which contains a formula which does some
calculation or even something like "=d6" (no the quotes aren't in the actual

Spreadsheet 2 contains a "Link to External Data" link to the cell in Spreadsheet 1.

When the link updates itself, it inserts the *formula* ("=d6") into the cell in
Spreadsheet 2, and not the *result* of the calculation.

This is a defect. In fact there seems to be no way to do what I can do inside a
single spreadsheet: decide whether I'm linking to the data or to the formula itself.
Comment 1 jbf.faure 2010-04-04 07:11:24 UTC
I confirm the described behaviour but I do not know if it is a defect or a feature.
To get the value instead of the formula, please try a formula like this :

Regards. JBF

Comment 2 Edwin Sharp 2013-03-08 12:34:17 UTC
Insert - Link to External Data... doesn't work.
After selecting external data source, the OK button is disabled and the Available tables/ranges is blank.
Rev. 1400866