https://bugs.documentfoundation.org/show_bug.cgi?id=94540
Bug ID: 94540
Summary: EDITING: VLOOKUP wrong result #VALUE in CALC 5.0.2.2
Product: LibreOffice
Version: 5.0.2.2 release
Hardware: Other
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Tested with LibreOffice Version: 5.0.2.2
Build ID: 37b43f919e4de5eeaca9b9755ed688758a8251fe
Locale: es-MX (es_MX)
On Windows 10
Description:
Function VLOOKUP en LO Calc 5.0.2 display #VALUE instead of the correct result.
In LO 4.4.5 works correct.
Steps to reproduce
Open test file in LO Calc 4.4.5 and see the yellow column named “ciclo” (cycle)
the result is a number of cycle depending on the date cycle 1 = C1, cycle 2 =
C2, etc.
the table of this is in the “parametros” (parameters) sheet.
In LO Calc 5.0.2 the result of the function displays #VALUE, instead of the
correct result.
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
