https://bugs.documentfoundation.org/show_bug.cgi?id=132131
--- Comment #12 from Julien Nabet <[email protected]> ---
Taking a look at
https://opengrok.libreoffice.org/xref/core/sc/source/core/tool/interpr1.cxx?r=61d8db6b#7204
7204 void ScInterpreter::CalculateLookup(bool bHLookup)
7205 {
...
7210 // Optional 4th argument to declare whether or not the range is
sorted.
7211 bool bSorted = true;
7212 if (nParamCount == 4)
7213 bSorted = GetBool();
7214
...
7299 if ( bSorted )
7300 rEntry.eOp = SC_LESS_EQUAL;
So when there's no final ";", it's considered as true.
so
VLOOKUP($A$2;$C$2:$E$5;2)
is equivalent to
VLOOKUP($A$2;$C$2:$E$5;2;1)
VLOOKUP($A$2;$C$2:$E$5;)
is equivalent to
VLOOKUP($A$2;$C$2:$E$5;2;false)
About difference with numbers, I think it's the same behaviour,
if you put this in C10:D11
2 test2
1 test1
then =VLOOKUP(1;C10:D11;2)
you got "N/A"
--
You are receiving this mail because:
You are the assignee for the bug._______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
