XlxsFormatProvider: CellSelection GetResultValueAsString does not process function XLOOKUP

[Bart]

Hi,

It looks like that there is no support for the XLOOKUP function.  Result is "#NAME?"

Can you give me any tips to get around this issue?

Regards,

Bart

[Dimitar]

Hello Bart,

This function is not supported at the moment. I have added a feature request for it on our feedback portal. You can track its progress, subscribe to status changes, and add your comment to it here. I have updated your Telerik points as well. 

Currently, a possible solution is to write a custom function. An example of this is available in our SDK repository: xaml-sdk/Spreadsheet/WPF/CustomFunctions at master.

Should you have any other questions do not hesitate to ask.

Regards,
Dimitar
Progress Telerik