When a cell is of type text, leading zero's are stripped out

[Grant]

Hi,

I'm trying to use the ejSpreadsheet in an app and want to have a column where users can enter text, which in some cases will contain leading zeros. If I format the cells as text, any content is allowed except for leading zero's, which get stripped off. 

This behaviour is evident on your own demos: 

http://js.syncfusion.com/demos/web/#!/bootstrap/spreadsheet/defaultfunctionalities

Select a range of cells, change the type to 'text' using the ribbon then try to enter text with a leading zero. The text 009 gets stripped to 9. This is contrary to how Excel behaves.

Please advise if  there is a way to allow users to enter any text, even if it is multiple 0's followed by a number.

thanks

[Shanmugaraja K]

Hi Grant, 

 

Thank you for using Syncfusion products, 

 

We have considered this “When the cell has text type, leading zeros are not maintained” as an issue and a support incident has been created under your account to track the status of this requirement. Please log on to our support website to check for further updates. 

 

https://www.syncfusion.com/account/login?ReturnUrl=/support/directtrac/incidents  

 

Regards, 

Shanmugaraja K