SpreadJS - the pivot panel can't update/refresh after import spread sheet

SpreadJS - the pivot panel can't update/refresh after import spread sheet

Posted by: kit.leung on 3 September 2024, 5:07 am EST

• 

  kit.leung

  • Post Options:
  • Link
    Copy

  Posted 3 September 2024, 5:07 am EST

  SpreadJS - the pivot panel can’t update/refresh after import spread sheet from file
  
  please see the screenshot for details.

  1. do the export file included pivot table metadata or not?
  2. how can i sync the pivot panel as same as exported version?

  Best Regards,
  
  Kit

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 4 September 2024, 4:55 am EST

  Hi Kit,

  I didn’t find any screenshots attached, and I am having trouble understanding both points clearly. Could you please elaborate further with an example? To better assist you, please share a sample along with the steps to replicate the behavior you observed, or modify the existing sample to demonstrate the issue. This will help me investigate the problem more thoroughly. Additionally, a GIF or video illustrating the issue would be very helpful.

  Regards,
  
  Priyam

• 

  kit.leung

  • Post Options:
  • Link
    Copy

  Posted 6 September 2024, 4:17 am EST

  SpreadJS - Export and Import.zip

• 

  kit.leung

  • Post Options:
  • Link
    Copy

  Posted 6 September 2024, 4:18 am EST

  Hi Priyam,

  i forgot to add the zip file.
  
  please see the zip file for detail.
  
  Thanks

  Kit

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 9 September 2024, 5:38 am EST - Updated 9 September 2024, 5:43 am EST

  Hi,

  I attempted to replicate the behavior on my end using the available information but was unable to do so. On my side, the pivot table does not display a black pivot panel after import. Please refer to the attached “Steps.gif” and the sample below.

  Gif:

  Sample: https://jscodemine.mescius.io/share/zkaBHr6MvEKidn67fpXp0w/?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"ActiveFile"%3A"%2Fsrc%2Fapp.js"}

  Could you please try with the latest version, 17.1.4? If you still face the issue, could you share a sample along with the steps to replicate the behavior you observed, or modify the existing sample to demonstrate the issue? This will help me investigate the problem further. Additionally, it would be helpful if you could provide a GIF or video illustrating the issue.

  Regards,
  
  Priyam