DateTime Workbook Formats

DateTime Workbook Formats

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

• 

  dean.kinnear

  • Post Options:
  • Link
    Copy

  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