[Libreoffice-bugs] [Bug 117714] Libreoffice Calc issues with function (named "procv" in portuguese) that returns wrong values

2018-05-20 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=117714

m.a.riosv  changed:

   What|Removed |Added

 Status|UNCONFIRMED |RESOLVED
 CC||miguelangelrv@libreoffice.o
   ||rg
 Resolution|--- |NOTABUG

--- Comment #2 from m.a.riosv  ---
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.

-- 
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


[Libreoffice-bugs] [Bug 117714] Libreoffice Calc issues with function (named "procv" in portuguese) that returns wrong values

2018-05-20 Thread bugzilla-daemon
https://bugs.documentfoundation.org/show_bug.cgi?id=117714

--- Comment #1 from relaxqenca...@sapo.pt  ---
Created attachment 142214
  --> https://bugs.documentfoundation.org/attachment.cgi?id=142214=edit
test the function vlookup

-- 
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