Bug 153737 - After upgrading from LO to vLookup with DDE file descriptor does not work right
Summary: After upgrading from LO to vLookup with DDE file descriptor d...
Status: RESOLVED DUPLICATE of bug 152717
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
(earliest affected) release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
Depends on:
Blocks: Function-Vlookup
  Show dependency treegraph
Reported: 2023-02-19 15:08 UTC by Erich
Modified: 2023-02-21 01:08 UTC (History)
5 users (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 Erich 2023-02-19 15:08:57 UTC
Now vLookup does not return a value. When entering the function anew, wrong value gets returned.
Original function was :
The new function created with 7,4,5 is :
which works in 7.3.7 but not in 7.4.5

Steps to Reproduce:
1.Open file with vLookup functions

Actual Results:
Empty values returned

Expected Results:
corresponding values should be returned

Reproducible: Always

User Profile Reset: No

Additional Info:
Comment 1 m_a_riosv 2023-02-19 22:06:44 UTC
Please attach sample files.
Comment 2 Erich 2023-02-20 17:12:36 UTC
(In reply to m.a.riosv from comment #1)
> Please attach sample files.

Hello, that is sort of complicated, because it is our price list and proforma template.

However, looking to shrink the file and send it, I noticed, that the new file description uses forward slashes and my files used DDE with regular windows style backsalsh descriptors.

So I changed my route from :
=SI.ND(BUSCARV(D19,DDE("soffice","Z:\_TALLER\Archivos_Taller\precios\Precios.ods","LISTA_PRECIOS.$B$5:$C$5500"),2,0),"no hay valor")

to :
=SI.ND(BUSCARV(D19,'file:///Z:/_TALLER/Archivos_Taller/precios/PRECIOS.ods'#$LISTA_PRECIOS.$B$3:$D$5600,2,0),"no hay valor")

And that does the trick. Only problem being is that I have to edit several dozen templates and other files which have DDE file descriptors.

And here my final question : Has DDE been dropped after LO 7.3 ???

Thanks again for the help.
Comment 3 m_a_riosv 2023-02-21 01:08:32 UTC
Fixed for 7.4.6

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