I have an Excel file that has a bunch of VLOOKUP() calls in it. Viewing the Excel shows values in the respective cells. When I try to use Aspose to convert the Excel file to a PDF, all the cells that have the VLOOKUP() formula in the cell show up in PDF as #NAME?. Is there a way to get the value that shows in Excel to show up in the PDF?
Hi,
Please try the attached latest version/fix v6.0.0.4. Also, please call Workbook.CalculateFormula() method before saving to Pdf format.
If you still find the issue, kindly give us sample template Excel file and output Pdf file here, we will check it soon.
Thank you.