Bug 89980 - Paste as Linked Picture, paste special/Link not create DDE
Summary: Paste as Linked Picture, paste special/Link not create DDE
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected)
3.5.0 release
Hardware: Other All
: medium enhancement
Assignee: Not Assigned
Depends on:
Blocks: Paste-Special Files-Linked
  Show dependency treegraph
Reported: 2015-03-13 02:29 UTC by HD
Modified: 2020-04-12 09:56 UTC (History)
2 users (show)

See Also:
Crash report or crash signature:

Linked Image in Excel (202.51 KB, application/pdf)
2015-03-13 02:29 UTC, HD

Note You need to log in before you can comment on or make changes to this bug.
Description HD 2015-03-13 02:29:23 UTC
Created attachment 114063 [details]
Linked Image in Excel

It would be nice if Calc has "Paste as Linked Image".
This feature enables you to place tables which column width and row height are different,side by side. 
<See the attachment>

Calc has Link option in paste special menu, though you can't move table freely and links are not updated automatically.

Best regards.
Comment 1 raal 2015-03-13 16:38:53 UTC
calc  has this feature, as you wrote it's under the paste special/Link.

First problem I see that calc set this link as normal link, not as DDE. I tested with OOo and OOo paste function DDE into link. The link should be DDE automatic, see https://help.libreoffice.org/Common/Edit_Links#Automatic

LO write link as:  {='file:///tmp/Untitled 3.ods'#$Sheet1.A1:B2}
OOo wite link as:  {=DDE("soffice";"\\VBOXSVR\tmp\oo.ods";"List1.A1:B2")}

Setting to new and changing summary.
Links you can see in menu Edit/Links

Second problem is inability to move link area. This is possible in OOo, partially broken in LO 3.5 and broken in current LO. For this please create another bug and give me to cc.

Tested with Version:
Build ID: 3e3f0f5c3051ea982f8f753e0f3e51441e8f9496
TinderBox: Linux-rpm_deb-x86_64@46-TDF, Branch:libreoffice-4-4, Time: 2015-02-22_10:24:01
Comment 2 pierre-yves samyn 2015-05-10 05:37:45 UTC

(In reply to raal from comment #1)
> calc  has this feature, as you wrote it's under the paste special/Link.

It seems that you did not understand the request.
I advise you this short video that shows step by step what it is.


LibreOffice does *not* have this feature. It is not a bug but an enhancement request and I therefore update the Importance field.

Comment 3 Optional 2020-04-12 09:56:19 UTC
While this is not a widely used or known feature in Excel, it is a very useful and powerful feature. It would be a great enhancement to Calc.

At one point, this was called Camera in Excel if I recall correctly.

Is anyone making an extension or addon for this?