DateTime Workbook Formats

DateTime Workbook Formats

Posted by: dean.kinnear on 24 July 2025, 10:54 am EST

• 

  dean.kinnear

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 24 July 2025, 10:54 am EST

  When a user enters a datetime into a cell formatted as general, it is correcly formatted as a date time - can use month, day, year function on the date time value.

  When the workbook is saved back to the server, the cell now has a integer value (date) or a decimal value (datetime). Is there a way to persist the format the way Excel does?

  Thanks,
  
  Dean

• 

  chirag.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 25 July 2025, 2:00 am EST

  Hi,

  Apologies for the inconvenience caused.

  We can replicate the behavior you mentioned on our end. We are discussing this with the concerned team and will update you as soon as we get any information from their end.

  Internal Tracking ID: SJS-30839

  Kind Regards,
  
  Chirag Gupta

• 

  dean.kinnear

  • Post Options:
  • Link
    Copy

  Posted 16 September 2025, 12:17 pm EST - Updated 16 September 2025, 4:21 pm EST

  Using spreadjs version 18.2.2, the issue is not completely fixed.
  
  In the attached workbook, enter a date in the two cells (B1 & B2), then export.
  
  Only B1 is formatted as a date.

  

  1310×709 57.9 KB

  
  
  

• 

  chris.bannon

  

  • Post Options:
  • Link
    Copy

  Posted 16 September 2025, 4:14 pm EST

  Thanks for reporting, Dean. I have opened a related case.

  Internal tracking ID: SJS-31555

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 26 September 2025, 1:02 am EST

  Hi,

  The mentioned issue has been fixed in the latest version of SpreadJS V18.2.3. Kindly upgrade to the latest version of SpreadJS and let us know if you still face the same issue.

  You may also download the latest version using the following link: http://cdn.mescius.com/spreadjs/18.2.3/Files/SpreadJS.Release.18.2.3.zip

  Regards,
  
  Priyam

• 

  dean.kinnear

  • Post Options:
  • Link
    Copy

  Posted 26 September 2025, 7:09 am EST

  This fix in 18.2.3 looks good and is working.

  Thanks!
  
  Dean Kinnear