kendo-ui-core icon indicating copy to clipboard operation
kendo-ui-core copied to clipboard

Published 20 hours ago • verified publisher icon telerik

Spreadsheet does parse dates correctly and do not preserve date format on paste

Open nelito987 opened this issue 3 years ago • 0 comments

Bug report

Dates and times entered (or pasted) in the spreadsheet are incorrectly parsed and do not respect the specified format. For example, dd.MM.yyyy HH:mm becomes MM.dd.yyyy HH:mm. The issue is replicated even if a culture is set.

Reproduction of the problem

  1. Open the Dojo
  2. Add the following date in Excel file and paste it in the Spreadsheet - 10.01.2022 09:00

Current behavior

The Spreadsheet does not parse the dates correctly. 10.01.2022 09:00 (january 10th) becomes 01.10.2022 09:00 (october 1st) 13.01.2022 09:00 is not affected by this issue. 10.01.2022 (january 10th, without time) is not affected by this issue.

Expected/desired behavior

Spreadsheet should parse the dates as they are. Copy dates such as 10.01.2022 09:00 should remain 10.01.2022 09:00 without switching the month and date values

Environment

  • Kendo UI version: 2022.2.621
  • jQuery version: x.y
  • Browser: [all ]

nelito987 avatar Jul 15 '22 09:07 nelito987