[Libreoffice-bugs] [Bug 119659] LOOKUP function >> application crashes, if "Result vector" argument is array of constant with at least 1 empty cell, and search value is out of vector

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=119659

--- Comment #1 from Regis Perdreau <regis.perdreau at gmail.com> ---
Guess I have to replace ',' with ';' so i can enter
=LOOKUP(3 ;A1:C1; {;2} )

No result. The A2 cell is blank, no error message.

The help tells that the third parameter is a range of cell. What is exactly
expected with {,2} ? 


Version: 6.2.0.0.alpha0+
Build ID: 8854cf29682bc2f02fba1901f967c7a94bc706d5
CPU threads: 4; OS: Linux 4.15; UI render: default; VCL: gtk3; 
Locale: fr-FR (fr_FR.UTF-8); Calc: threaded

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20180903/ab67c316/attachment.html>