This is a migrated thread and some comments may be shown as answers.

Spreadsheet from file date issues

1 Answer 142 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Oscar
Top achievements
Rank 1
Oscar asked on 21 Feb 2017, 03:08 PM

Hello,

When importing data from a file (calling fromFile method, or using the open button of the control) that uses es-ES culture, date cells are rendered as in en-US format, although the value remains in es-ES format.

Is there any way to fix this issue?

1 Answer, 1 is accepted

Sort by
0
Veselin Tsvetanov
Telerik team
answered on 23 Feb 2017, 08:34 AM
Hi Oscar,

Here you will find a small Dojo sample, based on the scenario described. Attached you will find an xlsx file, which has a date with Spanish formatting in one of its cells.

After loading that file to the test Spreadsheet, the value in the cell is displayed as it is in the file. The value in the function bar, however, is displayed as dd/MM/yyyy. The reason for that is the fact, that the kendo.culture.es-ES.min.js does not contain a dash-like date format for Spanish culture. Therefore, the Spreadsheet defaults to the "d" format.

Here you will find a short video of running the test.

Regards,
Veselin Tsvetanov
Telerik by Progress
Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Tags
Spreadsheet
Asked by
Oscar
Top achievements
Rank 1
Answers by
Veselin Tsvetanov
Telerik team
Share this question
or