Numeric data formatted as date even when numeric format is present

4 posts, 0 answers
  1. Sandra Walters
    Sandra Walters avatar
    29 posts
    Member since:
    Dec 2005

    Posted 17 May Link to this post

    If a cell has a numeric format applied, either programmatically or via the UI, the data entered should be treated as a number if possible.  This is Excel's behavior if the user enters an ambiguous value - for example "1/30" - Excel will convert it to date, unless the cell has been formatted as text or numeric - in which case, Excel does not perform the conversion.

    I'm seeing that the kendo spreadsheet doesn't respect the numeric formatting in this manner.  If a numeric (or percentage) format is applied and the user enters "1/30" for example, the spreadsheet will convert this value to a date - 1/30/2016.

    The application in which I've implemented the spreadsheet control needs to support this behavior; is there a workaround so that the cell contents are not converted?
  2. Boyan Dimitrov
    Admin
    Boyan Dimitrov avatar
    1746 posts

    Posted 19 May Link to this post

    Hello Sandra Walters,

    I am afraid that there is no workaround and this is bit misleading behavior. I logged as an issue in our repository. 

    Thank you for your feedback. 

    Regards,
    Boyan Dimitrov
    Telerik
     
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
     
  3. Kendo UI is VS 2017 Ready
  4. Sandra Walters
    Sandra Walters avatar
    29 posts
    Member since:
    Dec 2005

    Posted 19 May in reply to Boyan Dimitrov Link to this post

    Hello Boyan Dimitrov,

    Thanks for the response.   However, I see the issue has already been closed because "the same happens in Google Sheets" (by mishoo).  It does however happen in Excel.

    Is Google sheets the standard then, and not Excel???

  5. Alex Gyoshev
    Admin
    Alex Gyoshev avatar
    2500 posts

    Posted 20 May Link to this post

    Hello Sandra,

    This is an implementation detail, and Google Sheets and Excel differ in their implementations. The Kendo UI Spreadsheet does not try to replicate all Excel features, since the Excel codebase has accumulated features over 30 years and has millions of lines of code, which is not optimal for a web widget.

    For the specific case, 1/30 is a computation, while 0.033 is a number. Users can input computations via formulas, and this can be serialized as a number from the server, therefore we do not find the lack of this extra code limiting to users or developers.

    Regards,
    Alex Gyoshev
    Telerik
     
    Join us on our journey to create the world's most complete HTML 5 UI Framework - download Kendo UI now!
     
Back to Top
Kendo UI is VS 2017 Ready