String changes to date

[Ryan Morgan]

Good day,

In the spreadsheet control any time you type a string that resembles a date or time, the format for the cell changes to Date.

For instance, if you go to the DataSource Binding demo at http://demos.telerik.com/aspnet-mvc/spreadsheet/datasource and type 10:00 PM in the ProductName column the current date will be displayed in the cell. If you type 10-10-10 it will be changed to 10/10/2010. If you type 10:99 it gets changed to 11:39.

So with a spreadsheet that is bound to a datasource. How do you force a column to keep the input string as a string?

Thanks and Regards

 

[Bozhidar]

Hi,

In order to force the value of the cell to be read as a string, you have to preface it with a ' symbol. For instance if you write '10:00 PM the value will be shown as you expect.

Regards,
Bozhidar
Telerik