Conversion EXCEL to PDF

[Gisler Joris]

Hello

I am trying to convert an Excel file to a PDF. My Excel uses functions like XLOOKUP and IF. I am using the XLOOKUP function for name search. on another sheet in the Excel file i have values for those names i am searching eith XLOOKUP. The IF function is used as displayed in the example

Example for one cell

=IF(XLOOKUP("Example";Table1[@Description];Table1[@Value])=1;"ý";"o")

My problem is now. When I open the PDF after the conversion, I don't see the values. It just looks like before the conversion. But if I am opening the Excel file that i generate alongside the PDF, I see the correct values.

My questions are:

Does anyone know if these functions are supported?

Or if there is another solution to this problem?

[Kurmitha Manickhaperumal]

Hi Gisler Joris,

 

We have reproduced the reported issue at our end and validating it currently. We will share the validation details on April 18, 2024. 

 

Regards,

Kurmitha M.

[Kurmitha Manickhaperumal]

Hi Gisler Joris,

 

XlsIO currently does not have support for “XLOOKUP” formula. We have logged "Provide support for XLOOKUP formula" as a feature request in our database. However, we don't have any immediate plans to implement this feature. we will implement this feature in any of our upcoming releases and will update you once it has been implemented.

 

You can track the status of the feature through the feedback link.

 

Regards,

Kurmitha M.