Excel to pdf data missing when using formula

Aspose.Cells Product Family
1

Hi,

I’m using aspose cells for .net and while converting the Excel to PDF, the cell where I have used formula(configured) is missing in my converted PDF. But while generating excel, the cell is showing the formula and also giving the correct calculated value. But in the PDF the data inside the cell is missing, This does not happen when I save the excel file again and convert it. It happens only for the first time the excel is generated and the file is directly converted to Pdf.

Thanks
Ravi
2

Hi,


Thanks for your query.

Please call Workbook.CalculateFormula() method before converting to PDF file, it should fix your issue. If you still find the issue, kindly provide us your template file here, we will check it soon.

Thank you.