Bug 121322 - Paste with 'Dynamic Data Exchange' does not use DDE function but inserts file link
Summary: Paste with 'Dynamic Data Exchange' does not use DDE function but inserts file...
Status: NEW
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Files-Linked
  Show dependency treegraph
Reported: 2018-11-10 00:05 UTC by Regina Henschel
Modified: 2023-02-23 15:50 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:


Note You need to log in before you can comment on or make changes to this bug.
Description Regina Henschel 2018-11-10 00:05:27 UTC
Launch Calc and create files "source.ods" and "target.ods".
Write number 123 to cell B3 in "source.ods", save.
Click on cell B3 and copy to clipboard, e.g using the icon.
Go to document "target.ods" and click on cell A4. Then open the drop-down list from "Paste" icon. Select item "Dynamic Data Exchange (DDE link)'.

Look in input bar.
You see something similar to ='file:///D:/Desktop/Quelle.ods'#$Sheet1.B3
It is a file link.

Expected: Something similar to =DDE("soffice";"D:\Desktop\Quelle.ods";"Sheet1.B3")

If you drag&drop with Ctrl+Shift, then a DDE link is generated. The DDE link works as expected. Changes in the source file are automatically reflected in the target file without need to press Strg+Shift+F9. Manually entering the function DDE works too.

You might argue about using DDE (see bug 49327), but if it is labeled 'Dynamic Data Exchange' it should use DDE funktion.

Suggestion: Provide both kind of links in the drop-down list of the insert icon.
Comment 1 Oliver Brinzing 2018-11-10 17:39:25 UTC
confirming with 

Version: (x64)
Build ID: 86daf60bf00efa86ad547e59e09d6bb77c699acb
CPU threads: 4; OS: Windows 10.0; UI render: default; 
Locale: de-DE (de_DE); Calc:
Comment 2 Oliver Brinzing 2018-11-10 17:42:15 UTC
already reproducible with

Build-ID: c838ef25c16710f8838b1faec480ebba495259d0
CPU-Threads: 4; BS: Windows 6.2; UI-Render: Standard; 
Gebietsschema: de-DE (de_DE); Calc: single
Comment 3 QA Administrators 2021-02-22 04:00:06 UTC Comment hidden (obsolete)
Comment 4 QA Administrators 2023-02-23 03:25:07 UTC Comment hidden (obsolete)
Comment 5 Regina Henschel 2023-02-23 15:50:18 UTC
The problem exists as described still in Version: (X86_64) / LibreOffice Community
Build ID: 9d44236a62bf59d120dda89924d0d1407b2bd52b
CPU threads: 8; OS: Windows 10.0 Build 19045; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: CL threaded