https://bugs.documentfoundation.org/show_bug.cgi?id=117714
Bug ID: 117714
Summary: Libreoffice Calc issues with function (named "procv"
in portuguese) that returns wrong values
Product: LibreOffice
Version: 6.0.3.2 release
Hardware: x86-64 (AMD64)
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: libreoffice-bugs@lists.freedesktop.org
Reporter: relaxqenca...@sapo.pt
Description:
the function "Procv" (in english named vlookup?) returns corrects values but
sometimes returns wrong values
Steps to Reproduce:
1.I create a database spreasheet
2.Then create a new spreadsheet where I want to return values by using a
vlookup (procv) function.
3.On the first line I start by introduce the function in to two cells, taking
care to enter $ in the cells that define the array, from were I want to obtain
the values.
4. Then I block copy the line to create new lines.
Actual Results:
Eges 1,10 1,00
Flour 1,20 2,00
Butter Brand 1 1,30 3,00
Butter Brand 2 #N/D #N/D Wrong value
Flour 9 3,80 28,00 Wrong value
Flour 10 1,40 4,00 Wrong value
Flour 11 1,70 7,00
Flour 12 1,80 8,00
Flour 13 1,90 9,00
Flour 14 2,00 10,00
Flour 15 2,10 11,00
Flour 16 2,20 12,00
Flour 17 2,30 13,00
Flour 18 2,40 14,00
Flour 19 2,50 15,00
Butter Brand 3 #N/D #N/D Wrong value
Flour 21 2,70 17,00
Flour 22 2,80 18,00
Flour 23 2,90 19,00
Flour 24 3,00 20,00
Flour 25 3,10 21,00
Flour 26 3,20 22,00
Flour 27 3,30 23,00
Flour 28 3,40 24,00
Flour 29 3,50 25,00
Flour 30 3,60 26,00
Flour 31 3,70 27,00
Expected Results:
Eges 1,10 1,00
Flour 1,20 2,00
Butter Brand 1 1,30 3,00
Butter Brand 2 1,40 4,00
Flour 9 1,50 5,00
Flour 10 1,60 6,00
Flour 11 1,70 7,00
Flour 12 1,80 8,00
Flour 13 1,90 9,00
Flour 14 2,00 10,00
Flour 15 2,10 11,00
Flour 16 2,20 12,00
Flour 17 2,30 13,00
Flour 18 2,40 14,00
Flour 19 2,50 15,00
Butter Brand 3 2,60 16,00
Flour 21 2,70 17,00
Flour 22 2,80 18,00
Flour 23 2,90 19,00
Flour 24 3,00 20,00
Flour 25 3,10 21,00
Flour 26 3,20 22,00
Flour 27 3,30 23,00
Flour 28 3,40 24,00
Flour 29 3,50 25,00
Flour 30 3,60 26,00
Flour 31 3,70 27,00
Flour 32 3,80 28,00
Reproducible: Always
User Profile Reset: Yes
OpenGL enabled: Yes
Additional Info:
I not sure what option to choose in "Hardware" so I´m using a i7-920 with
Windows 10 64 bits.
User-Agent: Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36
(KHTML, like Gecko) Chrome/64.0.3282.140 Safari/537.36 Edge/17.17134
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
Libreoffice-bugs@lists.freedesktop.org
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs