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

Force cell data type (text)

4 Answers 472 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Wayne Hiller
Top achievements
Rank 1
Veteran
Iron
Wayne Hiller asked on 17 Aug 2017, 04:08 PM
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?

4 Answers, 1 is accepted

Sort by
0
Misho
Telerik team
answered on 21 Aug 2017, 06:56 AM
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.
0
Wayne Hiller
Top achievements
Rank 1
Veteran
Iron
answered on 21 Aug 2017, 02:15 PM

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

 

0
Misho
Telerik team
answered on 22 Aug 2017, 06:18 AM
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.
0
Misho
Telerik team
answered on 29 Aug 2017, 03:20 PM
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.
Tags
Spreadsheet
Asked by
Wayne Hiller
Top achievements
Rank 1
Veteran
Iron
Answers by
Misho
Telerik team
Wayne Hiller
Top achievements
Rank 1
Veteran
Iron
Share this question
or