Need help with ScLookupCache

[Luboš Luňák]

On Thursday 16 of June 2022, Winfried Donkers wrote:
> Hi,
>
> I am implementing Excel function XLOOKUP in Calc (at a slow pace), and
> need some help with ScLookupCache.
>
> Am I correct when stating that ScLookupCache currently cannot cope with
> the combinations
>   eOp SC_GREATER_EQUAL and sorted in ascending order
> and
>   eOp SC_LESSER_EQUAL and sorted in descending order?

 No, it's not correct, why would you think that would be the case? As the name 
says, ScLookupCache is just a cache, so it stores the result of a lookup. It 
cares only what the operation was and its result, it doesn't care what the 
source data was (and it'll get discarded if the source data changes).

 The code for looking up in sorted data is in queryiter.cpp .

-- 
 Luboš Luňák
 l.lunak at collabora.com