1. Home
  2. Forum
  3. jQuery
  4. When a cell is of type text, leading zero's are stripped out

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

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


1 Reply
SK Shanmugaraja K Syncfusion Team November 7, 2016 08:54 AM UTC

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. 
 
 
Regards, 
Shanmugaraja K 


Loader.
Up arrow icon