Drop down values that end in a year formats cell as datetime string

Drop down values that end in a year formats cell as datetime string

Posted by: dean.kinnear on 19 February 2026, 12:56 pm EST

• 

  dean.kinnear

  • Post Options:
  • Link
    Copy

  Posted 19 February 2026, 12:56 pm EST - Updated 19 February 2026, 1:09 pm EST

  Please find attached workbook and video demonstration of bug.

  In worksheet, “Loan relationships”, cells $H$213:$H$218, select value in drop down:
  
  Non-trade Interest receivable in respect of VAT for periods beginning after 31 December 2022
  
  or
  
  Trade Interest receivable in respect of VAT for periods beginning before 1 January 2023

  Notice value is a text date in mm/dd/yyyy format.

  Demonstration.zip

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 20 February 2026, 5:01 am EST

  Hi,

  Thank you for providing the necessary details to reproduce the issue. At this time, we are unable to determine the root cause, so we have escalated the matter to our development team for further investigation.

  The internal tracking ID for this issue is SJS-33854. We will keep you informed as soon as we receive any updates.

  Regards,
  
  Priyam

• 

  chirag.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 13 March 2026, 1:52 am EST

  Hi Dean,

  The mentioned issue has been fixed in SpreadJS v19.0.5. The build for this version can be downloaded from the SpreadJS Downloads Page.

  Please let us know if you encounter any further issues or require additional assistance.

  Kind Regards,
  
  Chirag

  References:

  1. SpreadJS Download Page: https://developer.mescius.com/spreadjs/download