Completed
Last Updated: 11 Oct 2022 07:09 by ADMIN
Release R1.2023-Increment.1(09.Nov.2022)
Robert
Created on: 15 Jul 2022 09:10
Category: Spreadsheet
Type: Bug Report
0
Spreadsheet does parse dates correctly and do not preserve date format on paste

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 ]
0 comments