Force cell data type (text)

[Wayne Hiller]

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?

[Misho]

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

[Wayne Hiller]

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

 

[Misho]

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

[Misho]

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