SpreadJS does not honor excel visualization

SpreadJS does not honor excel visualization

Posted by: ablsoft on 26 January 2020, 3:02 am EST

• 

  ablsoft

  • Post Options:
  • Link
    Copy

  Posted 26 January 2020, 3:02 am EST

  Hi,

  We have a document and the column has the following values:

  Target 1
  Actual 1
  In Compliance? 1
  

  However, the column has a format of “Date” with type “14-Mar”, excel properly shows the listed values above, however, after converting excel to SpreadJS with the JS converter, it is reading the values as dates, which is incorrect, so the values change to:

  1-Jan
  1-Jan
  1-Jan
  
  ```.
  
  See a screenshot with the document opened in excel on the left-hand side, and the same doc converted to SpreadJS on the right.
  [img]https://gccontent.blob.core.windows.net/forum-uploads/file-551c9fac-83ea-4cf4-994a-4677ac0fa62b.jpg[/img]
  
  Here the sample excel file zipped.
  [zip filename="test.xlsx.zip"]https://gccontent.blob.core.windows.net/forum-uploads/file-ff77a839-40b9-42ca-acc3-764c3aaa1d00.zip[/zip]
  
  Is there a way to correct this behavior, please?
  
  Thanks, 
  David R

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 26 January 2020, 4:37 pm EST

  Hi David,

  Thank you for sharing the sample file. We are able to replicate the issue and hence we have forwarded it to the concerned team for further investigation of the issue. We will let you know about any further updates regarding the issue. The internal tracking ID for the issue is SJS-3277.

  Regards
  
  Sharad

• 

  ablsoft

  • Post Options:
  • Link
    Copy

  Posted 15 February 2020, 9:29 am EST

  Hi Sharad,

  Thanks for looking into this.
  
  We would like to know if there is an update on this fix. Our customer is highly concerned since this problem gives them the impression that their data is not properly preserved and they can not see the content as it was in their Excel spreadsheets. Is there an ETA?

  Thanks,
  
  ABLSoft

• 

  manish.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 17 February 2020, 7:13 pm EST

  Hi,
  
  Your issue has been fixed in the latest SpreaedJS release 13.0.5. Please get the list of fixed issues and the download link for 13.0.5 from the following link:
  
  [link]https://www.grapecity.com/my-account/devchannel[/link]

  Regards,
  
  Manish Gupta