Free Support Forum - aspose.com

Excel Dynamic Formulas lost when saving as PDF

I searched on the forums but couldn't find an answer to this.

I have an excel workbook that I'm using to create a report. I need to have it in PDF, and I chose ASPOSE over Reporting Services because it's generally easy to work with. I am putting a large dataset into various worksheets. Rather than perform more calculations in code, I'm dumping the data into hidden columns and having excel perform the simple calculations like division. (I couldn't find how to put variables into formulas, so I'm using dynamic formulas i.e. &=&=a{r}/b{r}). Everything works when I save to Excel, but all the formulas are lost when saving to PDF. Please tell me that you know how to make this work.

Thanks,
Sean

Hi,

Please call WorkbookDesigner.Workbook.CalculateFormula before saving to pdf file.

e.g

WorkbookDesigner designer = new WorkbookDesigner();
designer.Open(“e:\test\MyDesignerBook_new.xls”);
designer.SetDataSource(dt);
designer.Process(true);

designer.Workbook.CalculateFormula();
designer.Save(“e:\test\out__MyDesignerBook_new1.xls”);
designer.Workbook.Save(“e:\test\out__MyDesignerBook_new1.pdf”);

If you still find any issue, kindly post your sample console application, zip the archive and post it here with all the files. We will check it soon.

Thank you.