Re: Need help with ScLookupCache

2022-06-29 Thread Winfried Donkers
Luboš, Eike, Op 21-06-2022 om 15:12 schreef Winfried Donkers: 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? As Luboš already said, ScLookup

Re: Need help with ScLookupCache

2022-06-21 Thread Winfried Donkers
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? As Luboš already said, ScLookupCache just caches results of lookups, to be able to reuse them fo

Re: Need help with ScLookupCache

2022-06-20 Thread Eike Rathke
Hi Winfried, On Thursday, 2022-06-16 11:58:54 +0200, Winfried Donkers wrote: > 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? As Luboš al

Re: Need help with ScLookupCache

2022-06-20 Thread Winfried Donkers
Hi Luboš, 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 sa

Re: Need help with ScLookupCache

2022-06-20 Thread 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 sort

Need help with ScLookupCache

2022-06-16 Thread Winfried Donkers
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 de