[Libreoffice-bugs] [Bug 144777] countifs() in Calc is slower than Excel's countifs()

[bugzilla-daemon at bugs.documentfoundation.org]

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

--- Comment #15 from Eike Rathke <erack at redhat.com> ---
Order of evaluation matters, as compareByValue() and compareByString() may
deliver an exact match and only if they didn't then compareByRangeLookup() is
to be tried; see also its comment at
https://opengrok.libreoffice.org/xref/core/sc/source/core/data/table3.cxx?r=b60b6bfa#2941

Apart from that, COUNTIFS() doesn't do range lookups, only LOOKUP, MATCH and
[HV]LOOKUP do.

-- 
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/20210930/196a072c/attachment-0001.htm>