Excel workbook with pivot table corrupted after saving

Excel workbook with pivot table corrupted after saving

Posted by: yyoshimura on 7 February 2021, 6:28 pm EST

• 

  yyoshimura

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 7 February 2021, 6:28 pm EST

  Hi,

  We are facing a new problem when saving some file with pivot table connected to analysis service data source. Please refer attachment for reproduction.

  [AdHocReport_test.xlsx] can be opened by excel with no problem with a dialog prompted to connect to the data source.

  [AdHocReport_test_saved.xlsx] is the file saved using the API. It is corrupted when opened in Excel.

  We expected the behavior should be the same after saving without file corruption.

  Please help to investigate this issue. Thanks.

  gcexcelperformance.zip

• 

  yyoshimura

  • Post Options:
  • Link
    Copy

  Posted 7 February 2021, 6:30 pm EST

  By the way, we are using the latest version of Documents for Excel .NET with version v4.0.3.

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 9 February 2021, 10:31 pm EST

  Hello,

  We have escalated this to the developers and will let you know as soon as we get any update on this from the developers’ end.
  
  [Internal tracking id: 3747]

  Regards,
  
  Prabhat Sharma.

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 8 March 2021, 1:42 pm EST

  Hello,

  This issue has been fixed in the latest version of GcExcel i.e. 4.0.4.
  
  Please update it in your project to avoid the issue that you were facing.
  
  https://www.nuget.org/packages/GrapeCity.Documents.Excel/
  
  Regards,
  
  Prabhat Sharma.

• 

  yyoshimura

  • Post Options:
  • Link
    Copy

  Posted 8 March 2021, 4:10 pm EST

  We confirmed that the issue is solved using the latest version.
  
  Thank you for your great support.