We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Excel to PDF converter is fails with calculated field

Hi Support Team,
We are using Aspose.Cells dll for converting xls document to PDF . We are facing one issue when some calculated field values are appearing as 0 in PDF file whereas the same field contains some value in Excel file. Do you have known issues like this?
Below code snippet we are using :

Aspose.Cells.Workbook workbook = new Aspose.Cells.Workbook(source);
//Convert the Excell workbook as Pdf
workbook.Save(destination, Aspose.Cells.SaveFormat.Pdf);

@venkat2222,

Thanks for providing us sample code and details.

Please try calling Workbook.CalculateFormula() before rendering to PDF file format, it may fix your issue. If your issue still exists, kindly provide us your template Excel file here, we will check it soon.

Thank you very much Amjad . It worked for me :slight_smile: .

@venkat2222,

Good to know that your issue is sorted out by the suggested line of code. Feel free to contact us any time if you need further help or have some other issue or queries, we will be happy to assist you soon.