https://bugs.documentfoundation.org/show_bug.cgi?id=153737
Bug ID: 153737
Summary: After upgrading from LO 7.3.7.2 to 7.4.5.1 vLookup
does not work right
Product: LibreOffice
Version: 7.4.5.1 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
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.
--
You are receiving this mail because:
You are the assignee for the bug.
