[Libreoffice-bugs] [Bug 108268] EDITING: Vlookup doesn't work

[bugzilla-daemon at bugs.documentfoundation.org]

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

Julien Nabet <serval2412 at yahoo.fr> changed:

           What    |Removed                     |Added
----------------------------------------------------------------------------
             Status|UNCONFIRMED                 |NEW
                 CC|                            |serval2412 at yahoo.fr
     Ever confirmed|0                           |1

--- Comment #5 from Julien Nabet <serval2412 at yahoo.fr> ---
On pc Debian x86-64 with master sources updated today, I could reproduce this.
I noticed 2 things:
1) if I change the 4th parameter to 1 (true) it seems to work
2) if I copy paste a case on a brand new file, it works

Notice, I don't say it'd work for every case, just a case I took.
Indeed I create a brand new file with:
in cell A1 and B1, I put:
Assistance EDD adultes (9h30)

in cell C1, I put:
=VLOOKUP(B1;A1;1;0)
it works

In brief, I think there's some config on your file or on your cells/sheet, I
don't know, which make things fail.

-- 
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/20170601/c9a51f1e/attachment.html>