Bug 117714 - Libreoffice Calc issues with function (named "procv" in portuguese) that returns wrong values
Summary: Libreoffice Calc issues with function (named "procv" in portuguese) that retu...
Status: RESOLVED NOTABUG
Alias: None
Product: LibreOffice
Classification: Unclassified
Component: Calc (show other bugs)
Version:
(earliest affected)
6.0.3.2 release
Hardware: x86-64 (AMD64) Windows (All)
: medium normal
Assignee: Not Assigned
URL:
Whiteboard:
Keywords:
Depends on:
Blocks:
 
Reported: 2018-05-20 13:05 UTC by relaxqencaixa@sapo.pt
Modified: 2018-05-21 00:50 UTC (History)
1 user (show)

See Also:
Crash report or crash signature:

Attachments
test the function vlookup (19.41 KB, application/vnd.oasis.opendocument.spreadsheet)
2018-05-20 13:09 UTC, relaxqencaixa@sapo.pt 		Details
View All 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 relaxqencaixa@sapo.pt 2018-05-20 13:05:22 UTC 
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
Comment 1 relaxqencaixa@sapo.pt 2018-05-20 13:09:15 UTC 
Created attachment 142214 [details]
test the function vlookup
Comment 2 m_a_riosv 2018-05-21 00:50:10 UTC 
You are missing the fourth parameter of the function, what is needed if the searched list it is not sorted.

B9 =VLOOKUP(A9;$'Prices database'.$A$4:$'Prices database'.$C$33;2;0)

works fine.

Resolved as not a bug, please if you are not agree, reopen it.