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

Cell with text format removing leading zeros on workbook save

3 Answers 213 Views
Spreadsheet
This is a migrated thread and some comments may be shown as answers.
Ben
Top achievements
Rank 1
Ben asked on 23 Feb 2017, 03:54 PM

I've got a workbook that is writing values from a tab delimited file into a new excel workbook.

 

Within this, I've got cells that have values that are numbers but need to be formatted as text, as these numbers contain a leading zero.

 

I'm using the Telerik.Web.Spreadsheet namespace to do this and all seems to be working well until I save the file.

 

I've inspected my collection before calling the Save method on the workbook and the numbers in the cell are correct (i.e they have a leading zero) but as soon as I call save and open the file, the zeros are removed.

 

I've checked to make sure that the cells are being correctly formatted as text (they are all text) yet the cell consistently removes the leading zero.

 

What gives and how can I fix this? I've been at this for two days now and I'm getting nowhere - any help would be GREATLY received.

 

Kind regards,

 

Ben

3 Answers, 1 is accepted

Sort by
0
Ben
Top achievements
Rank 1
answered on 23 Feb 2017, 03:56 PM
I should state as well before I get a reply saying so - I've used the Cell.Format = "@", and I'm applying it BEFORE I set the value - as the documentation states.
Ben
Top achievements
Rank 1
commented on 23 Feb 2017, 04:07 PM

After some more searching I found this post within the forums:

http://www.telerik.com/forums/telerik-web-spreadsheet-removing-zeros-from-string-when-saving

 

When will this issue be rectified as this is the exact issue confirmed as a bug thatI am having?

Kind regards,

Ben

0
Nencho
Telerik team
answered on 28 Feb 2017, 10:59 AM
Hello Ben,

I am afraid that I cannot provide you with an exact timeframe for the fix release. However, I have increased the priority of the issue in question.

Regards,
Nencho
Telerik by Progress

Tore
Top achievements
Rank 1
commented on 18 Jan 2018, 09:27 AM

Any news on this issue? I have the exact same problem as Ben. 

 

However I'm using a slightly old version of the software, but will be willing to renew my license if this problem has been solved. 

 

Regards

Tore

0
Nencho
Telerik team
answered on 23 Jan 2018, 07:52 AM
Hello Tore,

At the time being, the bug is not yet fixed - https://github.com/telerik/kendo-ui-core/issues/2598. However, I have increased its priority and it is currently under consideration. We expect to have it soon fixed, and you can track the referenced issue above for its status.

Regards,
Nencho
Progress Telerik
Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Adriana
Top achievements
Rank 1
commented on 18 Jun 2022, 04:02 AM

Is this fixed? I'm having the same problem and it's 2022. In my case is worse because the trailing zeros are actually postal codes and the user want to do mail merge in which case the addresses will become "mush". How can I fix this? Anything I can do programmatically to display the 0s?
Lance | Manager Technical Support
Telerik team
commented on 22 Jun 2022, 04:54 PM

Hi Adriana, according to the tracked item, that specific issue has been fixed. If you are experiencing a similar behavior, please open a ticket here, share your implementation's code and the 'mush' end-result with us. This will let the team investigate independently and offer a solution more relevant to that implementation.
Tags
Spreadsheet
Asked by
Ben
Top achievements
Rank 1
Answers by
Ben
Top achievements
Rank 1
Nencho
Telerik team
Share this question
or