Sparkline not exported to xlsx

Sparkline not exported to xlsx

Posted by: martin.mayr on 17 May 2019, 1:10 am EST

• 

  martin.mayr

  • Post Options:
  • Link
    Copy

  Posted 17 May 2019, 1:10 am EST

  i export
  
  https://www.grapecity.com/demos/spread/JS/InspectorSample/
  
  to xlsx
  
  When i open with Libreoffice i see #NAME? instead of the sparklines.
  
  Is that supposed to work?

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 19 May 2019, 5:18 pm EST

  Hi,

  The issue is arising because Inspector sample showcases the formula sparklines which are supported in the SpreadJS but not in Excel. MS excel supports only three types of sparklines:
  
  • line
  
  • column
  
  • winloss
  
  These could be added into spreadJS using the setSparkline() method as demonstrated in the following sample:
  
  https://www.grapecity.com/demos/spread/JS/TutorialSample/#/demos/basicSparkline
  
  Sparklines added using the setSparkline() method are exported correctly and displayed correctly in MSExcel as demonstrated in the attached sample.
  
  Further, sparklines are not supported in LibreOffice so they won’t be visible while opening the file in LibreOffice Calc.

  Regards
  
  basicSparkline.zip