Unplanned
Last Updated: 23 Nov 2020 14:13 by n/a
n/a
Created on: 23 Nov 2020 14:13
Category: Spreadsheet
Type: Bug Report
0
Spreadsheet changes the date format to "mm-dd-yy" when importing from Excel

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 "05-15-20" screencast

Expected/desired behavior

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

Environment

  • Kendo UI version: 2020.3.1118
  • Browser: [all ]
0 comments