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

Free Support Forum - aspose.com

Workbook Formula does not working

Hi, I’m user who have license.


There is an error with aspose.cell 7.5.0.0

workbook.Save with FileFormatType.Excel97To2003 option is perfect.

but, When I convert workbook to pdf file using

workbook.Save with FileFormatType.Pdf option,

formula doen’t working (see red box in the picture)



I have attached my file

please, help


<span lang=“EN-GB” style=“font-size:9.0pt;font-family:
“Arial”,“sans-serif”;color:#002776;mso-ansi-language:EN-GB”>Eric Ahn
<span lang=“EN-GB” style=“font-size:12.0pt;font-family:“Arial”,“sans-serif”;color:#002776;
mso-ansi-language:EN-GB”>

<span lang=“EN-GB” style=“font-size:8.0pt;font-family:“Arial”,“sans-serif”;
color:#002776;mso-ansi-language:EN-GB”>Staff | Tax

Deloitte Anjin LLC

5Fl., One IFC, 23, Yoido-dong, Youngdeungpo-gu, Seoul, 150-945, Korea<o:p></o:p>

Direct: +82 (2) 6099 4329 | Fax: +82 (2) 6674 2420
kahn@deloitte.com | www.deloitteanjin.co.kr

cid:image001.jpg@01CDE9DF.E81791D0cid:image002.jpg@01CDE9DF.E81791D0

P Please consider the environment before printing



Hi,

Thanks for your posting and using Aspose.Cells.

We were able to find this issue. We have logged this issue in our database. We will look into it and resolve this issue. Once, the issue is resolved or we have some other update for you, we will let you know asap.

This issue has been logged as CELLSNET-41805.

Hi,


Could you download and try the latest fix/version: Aspose.Cells for .NET v7.5.0.4 and add a line before rendering to PDF if it works for you and the formulas are calculated fine.

workbook.CalculateFormula();

Thank you.

Hi,

Thanks for your posting and using Aspose.Cells.

Please call Workbook.CalculateFormula method before saving pdf file.

Please see the following code:

C#


Workbook workbook = new Workbook(@“D:\Filetemp\YearEndDeduction.xls”);

workbook.CalculateFormula();

workbook.Save(@“D:\Filetemp\dest.pdf”);



Hi,

Thanks for your posting and using Aspose.Cells for .NET.

We have fixed this issue.

Please download and try this fix: Aspose.Cells for .NET v7.5.0.5 and let us know your feedback.

The issues you have found earlier (filed as CELLSNET-41805) have been fixed in this update.


This message was posted using Notification2Forum from Downloads module by Aspose Notifier.