SpreadJS excel export time formatted cell problem

SpreadJS excel export time formatted cell problem

Posted by: ratmym on 28 April 2020, 2:39 am EST

• 

  ratmym

  • Post Options:
  • Link
    Copy

  Posted 28 April 2020, 2:39 am EST - Updated 3 October 2022, 10:21 am EST

  Dear, Admin.
  
  There is a problem regarding exporting time formatted cell.

  1. Enter hh:mm formatted text in a cell, such as “14:35”, in a spreadJS sheet.
  2. Export the sheet as an excel file.
  3. In the exported excel file, cell value has been changed.

  This problem also occurs in your demo page.

  Please see the attached image.

  

  854×722 34.8 KB

• 

  ratmym

  • Post Options:
  • Link
    Copy

  Posted 28 April 2020, 3:20 am EST

  • This problem happens in Chrome browser.
  • In case of Internet Explorer, cell value does not change.
• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 29 April 2020, 9:47 am EST - Updated 3 October 2022, 10:21 am EST

  Hi,

  We are sorry but we are unable to replicate the issue at our end. We have attached a gif of our observation, could you please have a look at it and let us know if we are missing something in order to replicate the issue
  
  
  
  Additionally, we have also tried without explicitly setting the formatted but the issue is not reproducible.
  
  Also, could you please share your machine configuration like browser version, OS, so that we may test on a similar environment too.

  Regards

• 

  ratmym

  • Post Options:
  • Link
    Copy

  Posted 29 April 2020, 9:23 pm EST - Updated 3 October 2022, 10:21 am EST

  My environment:

  • OS: Windows 10 64bit
  • Chrome: 81.0.4044.129
  • IE: 11
  • TimeZone: Asia/Seoul
  • Locale: ko_KR

  In Chrome browser,
  
  

  https://gccontent.blob.core.windows.net/forum-uploads/file-f1811c83-19d3-4761-b834-a554265a0e61.gif(image larger than 4 MB)

  Exported xlsx file
  
  

  

  927×455 17.1 KB

  ssjson difference between IE11 and Chrome,
  
  

  

  1255×64 6.66 KB

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 30 April 2020, 10:25 am EST

  Thank you for the additional information. It seems that the issue is arising with the Seoul timezone and hence we have forwarded it to the concerned team for further investigation of the issue. The internal tracking Id for the issue is SJS-4252. We will let you know about any updates regarding the same.

• 

  sharad.tomer

  

  • Post Options:
  • Link
    Copy

  Posted 18 May 2020, 3:13 am EST

  Hi,

  This issue is now fixed in our latest hotfix 13.1.1. Please update to the latest version and let us know if the issue persists for you. You may get the latest build from npm or download using the following link:
  
  http://cdn.grapecity.com/spreadjs/13.1.1/Files/SpreadJS.Release.13.1.1.zip

  Regards