Spreadsheet from file date issues

2 posts, 0 answers
  1. Oscar
    Oscar avatar
    185 posts
    Member since:
    Oct 2010

    Posted 21 Feb 2017 Link to this post

    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?

  2. Veselin Tsvetanov
    Admin
    Veselin Tsvetanov avatar
    1201 posts

    Posted 23 Feb 2017 Link to this post

    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.
Back to Top