Force cell data type (text)

5 posts, 0 answers
  1. Wayne Hiller
    Wayne Hiller avatar
    47 posts
    Member since:
    Sep 2005

    Posted 17 Aug Link to this post

    I am having an issue with the Spreadsheet automatically changing text entered into a cell to a number. For example if you enter 0001 into a cell the value will be automatically converted to 1. I need to be able to preserve the text as is "0001". If there any way to do this?
  2. Misho
    Admin
    Misho avatar
    161 posts

    Posted 21 Aug Link to this post

    Hello,

    The spreadsheet widget supports cell-formatting options which includes string formatting.
    Here is a sample:
    https://dojo.telerik.com/UHEpo/2
    You can find more information in the following article:
    http://docs.telerik.com/kendo-ui/controls/data-management/spreadsheet/format

    Regards,
    Misho
    Progress Telerik
    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.
  3. Wayne Hiller
    Wayne Hiller avatar
    47 posts
    Member since:
    Sep 2005

    Posted 21 Aug in reply to Misho Link to this post

    That works great, thank you.

    I did notice that there is no way to set a "Text" format in the end-user UI. It would be nice to have it there too.

     

    Wayne

     

  4. Misho
    Admin
    Misho avatar
    161 posts

    Posted 22 Aug Link to this post

    Hi,

    I'm happy to hear that the suggested solution fits your needs.

    In terms of having the "Text" format in the end-user UI the perfect place to suggest such a feature request or functionality improvement is the Kendo feedback portal. I encourage you to post any technical details and requirements, which will enable other developers to vote, and make sure that the idea will be evaluated by our PM and the dev team.

    Best Regards,
    Misho
    Progress Telerik
    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.
  5. Misho
    Admin
    Misho avatar
    161 posts

    Posted 29 Aug Link to this post

    Hi,

    I'm writing as a follow up to inform you that the text option will be added to Spreadsheet UI and this will be available in the next official release which is scheduled for mid of September.

    https://github.com/telerik/kendo-ui-core/issues/3524

    Best Regards,
    Misho
    Progress Telerik
    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