Inputting number value with zero (o) in front

Aspose.Cells Product Family
1

Hi, is there a way to input numbers with 0 in front. In excel this can be done by setting the cell format to text:

image.png (7.7 KB)

I changed the cell format of the file used to text but the 0 in front disappears in the GridJs.

A workaround is to input apostrophe before the number but it would be better if we don’t have to do this.

2

@abdelaspose
Sorry for the inconvenience。
We can reproduce this issue.
When the cell format is text,it shall keep the text as user enters.
We will improve it .
We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSGRIDJS-1298

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.