We use cookies to give you the best experience on our website. If you continue to browse, then you agree to our privacy policy and cookie policy.
Unfortunately, activation email could not send to your email. Please try again.
Syncfusion Feedback

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

Thread ID:

Created:

Updated:

Platform:

Replies:

127255 Nov 7,2016 02:59 AM UTC Nov 7,2016 08:54 AM UTC JavaScript 1
loading
Tags: ejSpreadSheet
Grant
Asked On November 7, 2016 02:59 AM UTC

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 [Syncfusion]
Replied On 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 


CONFIRMATION

This post will be permanently deleted. Are you sure you want to continue?

Sorry, An error occured while processing your request. Please try again later.

Warning Icon You are using an outdated version of Internet Explorer that may not display all features of this and other websites. Upgrade to Internet Explorer 8 or newer for a better experience.Close Icon

;