Pivot table external data source opening by Microsoft excel after export issue

Pivot table external data source opening by Microsoft excel after export issue

Posted by: qui.ha on 8 April 2024, 8:45 pm EST

• 

  qui.ha

  • Post Options:
  • Link
    Copy

  Posted 8 April 2024, 8:45 pm EST - Updated 8 April 2024, 8:51 pm EST

  Hi Spreadjs team,
  
  I’m encountering an issue with a pivot table that has an external data source. After exporting the data to xlsx format, I receive an error message.

  Excel completed file level validation and repair. Some parts of this workbook may have been repaired or discarded.
  
  Removed Feature: PivotTable report from /xl/pivotCache/pivotCacheDefinition1.xml part (PivotTable cache)
  
  Removed Feature: PivotTable report from /xl/pivotTables/pivotTable1.xml part (PivotTable view)
  
  Removed Records: Workbook properties from /xl/workbook.xml part (Workbook)

  

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 9 April 2024, 7:51 pm EST

  Hi,

  Based on the information provided, I’m unable to reproduce the issue on my end. To provide better assistance, could you please share a sample along with the steps to replicate the behavior you have observed? Alternatively, you can modify the below provided samples to replicate the issue. Additionally, a GIF or video illustrating the problem would be helpful for us to understand the issue better. Without replicating the behavior, it will be challenging for us to assist you effectively.

  Samples for replicating the behavior:

  spread sample: https://jscodemine.mescius.io/share/Meu2eE6h70icOS657Nbwrw/?IsEmbed=false&Theme=Unset&PreviewDirection=0&IsEditorShow=true&IsExplorerShow=true&IsPreviewShow=true&IsConsoleShow=true&IsRunBTNShow=false&IsResetBTNShow=false&IsOpenInCodemineBTNShow=false&PanelWidth=20&PanelWidth=50&PanelWidth=30&defaultOpen={"OpenedFileName"%3A["%2Findex.html"%2C"%2Fsrc%2Fapp.js"%2C"%2Fpackage.json"]%2C"ActiveFile"%3A"%2Fsrc%2Fapp.js"}

  designer sample: https://jscodemine.mescius.io/share/rp2Yo73G0UCjCawlTsPuWA/?defaultOpen={"OpenedFileName"%3A["%2Findex.html"]%2C"ActiveFile"%3A"%2Findex.html"}

  Regards,
  
  Priyam

• 

  qui.ha

  • Post Options:
  • Link
    Copy

  Posted 14 April 2024, 1:39 pm EST - Updated 14 April 2024, 6:03 pm EST

  Dear SpreadJs Team,
  
  You can use the attached file to reproduce the issueissue pivot.zip

• 

  qui.ha

  • Post Options:
  • Link
    Copy

  Posted 14 April 2024, 6:02 pm EST

  Dear SpreadJs Team,
  
  You can see the attached file to reproduce the issue
  
  pivot external data source.zip

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 14 April 2024, 11:41 pm EST

  Hi,

  I was able to replicate the behavior on my end and escalated it to the concerned team. The internal track ID is “SJS-21793”. I will update you as soon as get any information.

  Regards,
  
  Priyam

• 

  qui.ha

  • Post Options:
  • Link
    Copy

  Posted 23 April 2024, 1:30 pm EST

  Hi SpreadJs team,
  
  Any update on this ticket?

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 23 April 2024, 10:52 pm EST

  Hi,

  I’ve reached out to the concerned team for an update, and I’ll inform you as soon as I receive any information.

  Regards,
  
  Priyam

• 

  qui.ha

  • Post Options:
  • Link
    Copy

  Posted 8 May 2024, 1:32 pm EST

  Hi SpreadJs team,

  Any update on this ticket?

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 8 May 2024, 11:13 pm EST

  Hi,

  The developer has notified us that the current pivot table does not have support for an external data source, which is the root cause of this issue. To address this limitation, two enhancement stories have been created: “SJS-23969” and “SJS-23971”. Unfortunately, there is no estimated time of arrival (ETA) for these enhancements at the moment. I’ll keep you informed as soon as I receive any updates on this.

  Regards,
  
  Priyam