Excel workbook saved as PDF problem

Posted by: yyoshimura on 9 March 2022, 12:41 pm EST

  • Posted 9 March 2022, 12:41 pm EST

    Hi,

    We have a workbook to be saved as PDF. When enable calculation is ON before saving workbook to PDF, the chart is not updated to the latest data. Please refer attachment for reproduction. Case 2 and case 3 is not working as expected.

    Please help to investigate this issue. Thank you.

    Regards

    GcExcelTest.zip
  • Replied 9 March 2022, 5:08 pm EST

    Hello,

    Thank you for reporting this issue.
    We too can observe the issue and escalated this to the development team for investigation. We will let you know as soon as we get any update on this from their end.
    [Internal Tracking ID: DOCXLS-5682]

    Regards,
    Prabhat Sharma.
  • Marked as Answer

    Replied 22 March 2022, 10:06 pm EST

    Hello,

    I am glad to inform you that the issue has been fixed in the 5.0.5 release of GcExcel. Please update your application with the latest builds to resolve this issue:
    https://www.nuget.org/packages/GrapeCity.Documents.Excel/5.0.5

    After fixing, for Case1, Case 2, Case3, pdfs are fine.
    for case 4, because workbook.EnableCalculation = false, so after filling data, the "合計" values are not updated, thus chart is not updated too.

    Regards,
    Prabhat Sharma.
Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels