Bug 153737 - After upgrading from LO 7.3.7.2 to 7.4.5.1 vLookup with DDE file descriptor does not work right
Summary: After upgrading from LO 7.3.7.2 to 7.4.5.1 vLookup with DDE file descriptor d...
Status: RESOLVED DUPLICATE of bug 152717
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
7.4.5.1 release
Hardware: All Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks: Function-Vlookup
  Show dependency tree / graph
 
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:

Attachments
Add an attachment (proposed patch, testcase, etc.)

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 
Description:
Now vLookup does not return a value. When entering the function anew, wrong value gets returned.
Original function was :
VLOOKUP(D19,DDE("soffice","Z:\_TALLER\Archivos_Taller\precios\Precios.ods","LISTA_PRECIOS.$B$5:$C$5500"),2,0)
The new function created with 7,4,5 is :
LOOKUPV(D19,'file:///Z:/_TALLER/Archivos_Taller/precios/PRECIOS.ods'#$LISTA_PRECIOS.$B$34:$C$71,2,0)
which works in 7.3.7 but not in 7.4.5


Steps to Reproduce:
1.Open file with vLookup functions
2.
3.

Actual Results:
Empty values returned

Expected Results:
corresponding values should be returned


Reproducible: Always


User Profile Reset: No

Additional Info:
N.A.
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 ***