[GH #3505] Time display problem

Tags: #<Tag:0x00007f0b0289f300> #<Tag:0x00007f0b0289ee28>

I’m using date picker and in hot column i’ve defined date format like “DD/MM/YYYY HH:MM” and type="date ", If i select date by default it’ll display like “10/10/2018 00:12”.

  1. If i modify that selected value like “10/10/2018 08:12” and click outside, This value become change to old value like “10/10/2018 00:12”.
  2. I’ll try to change that value like “10/10/2018 00:12” to “10/10/2018 08:15” and click out side it’s working fine.

Here the issue is in month.If month value is greater then 12 and click outside it’ll taking,If month value is less then 12 the modified value is not affecting, It’ll taking default value.

Please give me solution for this problem.

Hey @aya.sugimura

are you able to replicate the issue using this demo https://jsfiddle.net/1dvr02pk/?

ps. please notice that we are able to show time with date but we do not support this format (only date and time separately)

In handsontable, The present value is “10/12/2018 00:12” , Now change that value like “10/12/2018 10:12” after that, Please click on the handsontable header or handsontable any cells , Then “10/12/2018 10:12” value is converted into “10/12/2018 00:12”

If i click outside side the handsontable it’s working fine, If i click inside any where in the the handsontable the data is not affecting,

I can see what you mean. Thank you for sharing additional description. However it happens only for a cell with a time attached to a date cell type. As mentioned before this is something that we do not support. This type of cell would need to have a data-time-picker attached to understand this change. Here is a related topic https://github.com/handsontable/handsontable/issues/3505

Thank you for response, Is there any datetime picker in angular with handsontable except pikaday and JQuery plugin,

I am sure that you’d be able to attach something else but we only officially support Pikaday

Ok. Thank you.

you’re welcome