Excel workbook saved as PDF problem

Excel workbook saved as PDF problem

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

• 

  yyoshimura

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  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

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 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.

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 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.