https://bugs.documentfoundation.org/show_bug.cgi?id=153737

--- Comment #2 from Erich <[email protected]> ---
(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.

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to