telerik / kendo-ui-core

An HTML5, jQuery-based widget library for building modern web apps.
http://www.telerik.com/kendo-ui
Other
2.54k stars 1.91k forks source link

Spreadsheet changes the date format to "mm-dd-yy" when importing from Excel #6153

Open nelito987 opened 3 years ago

nelito987 commented 3 years ago

Bug report

When importing from Excel in Spreadsheet if a date is entered, but the date format is not set explicitly, the imported date always has the following format: "mm-dd-yy". The issue is observed even if a culture is set.

Reproduction of the problem

  1. Open the Dojo example
  2. Import the following file DateFormat.xlsx

Current behavior

The value in Excel is "15.6.2020" , but the imported date in the Spreadsheet is "06-15-20" screencast

Expected/desired behavior

The format of the dates should be the same as in the imported file.

Environment

Matesax commented 1 year ago

Still problem - JSON from Spreadsheet is changes the date format.