Behaviors of pivot table changed after saving

Behaviors of pivot table changed after saving

Posted by: yyoshimura on 7 April 2021, 7:04 pm EST

• 

  yyoshimura

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 7 April 2021, 7:04 pm EST - Updated 29 September 2022, 6:34 am EST

  Hi

  We noticed that the behaviors of pivot table changed after saving using the API.

  Reproduction steps:

  1. Create a workbook with pivot table (We are using SSAS data source).
  2. Expand the result like following.

  

  1716×892 71.5 KB

  3. Save the workbook using API
  4. Open the file again, the pivot table will be changed like following.
     
     
     

     1510×518 67.8 KB

  We hope that the behavior of pivot table should be the same after saving.
  
  Please help to investigate this issue. Thank you.

  The program used to generate the files is as following.
  
  gcexcelperformance.zip

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 8 April 2021, 5:30 pm EST

  Hello,

  We do not face the issue at our end with the latest build 4.0.5 by running your attached sample.
  
  If you are not using the latest API then please check once with it and if the issue still occurs then please share the environment details and MS Excel version on which you are opening the saved excel.

  Regards,
  
  Prabhat Sharma.

• 

  yyoshimura

  • Post Options:
  • Link
    Copy

  Posted 8 April 2021, 6:44 pm EST

  We can confirm that the problem still occurs with the latest build v4.05.

  Sorry for omitting some very important prerequisites.

  You need to connect to a working SSAS data source. The problem occurs after the first successful update of the pivot table.

  The attached sample Excel file cannot be reproduced because it is connecting to our internal testing SSAS database. We cannot find an open SSAS data source online to provide a working reproduction. Hope that the point was made clear and sorry for the inconvenience.

• 

  yyoshimura

  • Post Options:
  • Link
    Copy

  Posted 8 April 2021, 7:16 pm EST

  We have made a reproduction video. Please refer attachment. Thank you.

  2021-04-09_17h10_17.zip

• 

  yyoshimura

  • Post Options:
  • Link
    Copy

  Posted 8 April 2021, 7:20 pm EST

  And this is a video with the file before saving with API which is working as expected.

  2021-04-09_17h18_36.zip

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 11 April 2021, 11:07 pm EST

  Hello,

  If you can share the backup of the database file [.abf] file then it will be very helpful for us to replicate the issue at our end.
  
  If the data is confidential then you can create a case on the MySupport portal and share the file over there as it is completely confidential.
  
  https://www.grapecity.com/my-account/my-support

  Regards,
  
  Prabhat Sharma.

• 

  yyoshimura

  • Post Options:
  • Link
    Copy

  Posted 12 April 2021, 10:38 am EST

  Surely and here is the SSAS backup file.

  DEMOV6.zip

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 12 April 2021, 9:49 pm EST

  Hello,

  Thank you for sharing the file.
  
  I have forwarded it to the developers and will let you know as soon as we get any update on this from their end.
  
  [Internal Tracking ID: 3973]

  Regards,
  
  Prabhat Sharma.

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 27 April 2021, 11:53 pm EST

  Hello,

  The developers could not reproduce the problem using the given DEMOV6.abf.
  
  Here’s the steps they followed:

  1: Create a SSAS database “MultiDB”
  
  2: Use DEMOV6.abf to restore “MultiDB”
  
  3: The restore action is completed successfully.
  
  4: Use restored data source to refresh pivot table

  At last, they got an error that says Could not get data from an external data source. [screenshot 6.png]

  Could you help to check if the backup file or my steps are correct?

  Regards,
  
  Prabhat Sharma.
  
  Steps.zip

• 

  yyoshimura

  • Post Options:
  • Link
    Copy

  Posted 5 May 2021, 11:19 am EST

  Sorry for the confusion. Here is the correct backup file.

  DEMOv61.zip

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 6 May 2021, 2:00 pm EST

  Hello,

  Thank you for the file. We have forwarded it further for investigation.

  Regards,
  
  Prabhat Sharma.

• 

  prabhat.sharma

  

  • Post Options:
  • Link
    Copy

  Posted 20 May 2021, 11:04 pm EST

  Hello,

  The issue has been fixed in the latest version of GrapeCity.Documents.Excel 4.1.1.
  
  Please upgrade your project with the latest package to resolve this issue:
  
  https://www.nuget.org/packages/GrapeCity.Documents.Excel/

  Regards,
  
  Prabhat Sharma.

• 

  yyoshimura

  • Post Options:
  • Link
    Copy

  Posted 23 May 2021, 10:53 am EST

  We confirmed that this issue is fixed in the latest version. Thank you for you kind support.