Bug 153067 - LO 7.4.3: The DDE() function no longer returns contents of the destination file
Summary: LO 7.4.3: The DDE() function no longer returns contents of the destination file
Status: RESOLVED DUPLICATE of bug 152717
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:
Reported: 2023-01-17 12:57 UTC by kohl.ibri
Modified: 2023-01-17 13:27 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:
Regression By:

Example in V7.4.2 (173.66 KB, image/png)
2023-01-17 12:59 UTC, kohl.ibri
Example V7.4.4 (339.16 KB, image/png)
2023-01-17 13:00 UTC, kohl.ibri

Note You need to log in before you can comment on or make changes to this bug.
Description kohl.ibri 2023-01-17 12:57:15 UTC
After update to LO 4.3, the DDE-function no longer returns the specified cell content of the target file, e.g.

In file "d:\var\Temp\calc\file01.ods", "Table1.A1" the cell content is "DDE element 1".
In file "d:\var\Temp\calc\file02.ods", "Table1.B1" file1.ods is accessed with function "=DDE("soffice"; "D:\var\Temp\calc\file1.ods"; "Pos1.A1";0)".

Result in "file2.ods":
- LO 7.4.2: "DDE element 1".
- LO 7.4.3: ""

Steps to Reproduce:
1. create destination calc file, e.g. file1.ods
2. Write some Data to Table/Cell e.g. in "Table1.A1"
3. create test calc file, e.g. file2.ods
4. Set in a cell the DDE-function, e.g. "=DDE("soffice";"file1.ods";"Table1.A1";0)

Actual Results:
LO 7.4.3: Instead of Data of target file/Table/Cell, nothing (sometimes #NV) is shown

Expected Results:
LO 7.4.2: Data of target file/Table/Cell is shown

Reproducible: Always

User Profile Reset: Yes

Additional Info:
Version: (x64) / LibreOffice Community
Build ID: 1048a8393ae2eeec98dff31b5c133c5f1d08b890
CPU threads: 2; OS: Windows 10.0 Build 19044; UI render: Skia/Raster; VCL: win
Locale: de-DE (de_DE); UI: de-DE
Calc: threaded

Downgrading from 7.4.3 to 7.4.2 the DDE-function is working again.

Upgrading to 7.4.4: is still broken
Comment 1 kohl.ibri 2023-01-17 12:59:26 UTC
Created attachment 184708 [details]
Example in V7.4.2
Comment 2 kohl.ibri 2023-01-17 13:00:29 UTC
Created attachment 184709 [details]
Example V7.4.4
Comment 3 Xisco Faulí 2023-01-17 13:27:49 UTC
Thanks for reporting this issue.
This is a duplicate of bug 152717

*** This bug has been marked as a duplicate of bug 152717 ***