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? And if so, can anyone help me in making this possible? Winfried