When I open an Excel file in Calc and it contains, for example, the XLOOKUP function, there is a prefix =_xlfn next to the function. I know this is because Calc does not support the XLOOKUP function. Is there any way to use the =_xlfn. prefix to make the function written in Calc itself work in the latest version of Excel? What is the correct way to use the prefix when doing this? I want the other side to see the correct use of the XLOOKUP function in the Excel sheet, so using the equivalent of the INDEX and MATCH functions is not an option for me. How should I proceed correctly?
Thanks for your answers.