Export 2 Charts to xlsx - 1 color missing in MS Excel - LibreOffice OK

Export 2 Charts to xlsx - 1 color missing in MS Excel - LibreOffice OK

Posted by: martin.mayr on 5 November 2018, 6:17 am EST

• 

  martin.mayr

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 5 November 2018, 6:17 am EST

  I create 2 bar charts in, the second is with negative values
  
  https://www.grapecity.com/en/demos/spread/JS/InspectorSample/

  Then i export to xlsx.

  Then i open the xlsx with MS Excel 2013 → color of the second bar chart is missing
  
  When i open the xlsx with LibreOffice → color of the second bar chart is OK

  I attached the exported xlsx.

  When i try the same with 2 bar charts containing only positive values it works with MS Excel also

• 

  martin.mayr

  • Post Options:
  • Link
    Copy

  Posted 5 November 2018, 6:25 am EST

  exportPosNeg20181105202215.zip

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 6 November 2018, 12:20 am EST

  Hello,

  I am able to replicate this issue at our end. I have escalated the same to the development team for further investigation. I will let you know as soon as I get an update on it.
  
  The bug id for this issue is 266936.

  Thanks,
  
  Deepak Sharma

• 

  martin.mayr

  • Post Options:
  • Link
    Copy

  Posted 7 January 2019, 9:02 pm EST

  is this resolved in SpreadJS v12?

• 

  grapecity

  • Post Options:
  • Link
    Copy

  Posted 8 January 2019, 10:13 pm EST

  Hello,

  This issue has been fixed in SpreadJS v12.0, please download the latest build from here:
  
  http://cdn.grapecity.com/spreadjs/12.0.5/Files/SpreadJS.Release.12.0.5.zip

  Thanks,
  
  Deepak Sharma